ZTable open duration...

[CoyotteDundee]

Hi all,
I experience what is not really a problem (but...) with a TZTable component.
When I open an SQLite 3 table containing +- 300.000 records, user have to wait for a little bit more than 7 seconds before regaining application control.
Having a little bit investigated the code execution, it appears that the function

Code: Select all

TZAbstractRODataset.CreateResultSet(const SQL: string;
  MaxRows: Integer)

is called with a MaxRows value of -1, meaning "fetch all".
The -1 is passed by the calling statement in InternalOpen

Code: Select all

 ResultSet := CreateResultSet(FSQL.Statements[0].SQL, -1)

Is there an option to bypass the "fetch all" action and limit opening fetching to something lighter (and faster) ?
Did I miss some configuration value ?

Thank in advance for your responses,

Michel