ZTable open duration...
Posted: 24.06.2014, 10:44
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 is called with a MaxRows value of -1, meaning "fetch all".
The -1 is passed by the calling statement in InternalOpen
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
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)The -1 is passed by the calling statement in InternalOpen
Code: Select all
ResultSet := CreateResultSet(FSQL.Statements[0].SQL, -1)Did I miss some configuration value ?
Thank in advance for your responses,
Michel