TOPIC:

Excessive memory consumption by the TSQLQuery.Last positioning method to the end of a fairly large SQLite table.

A small program for behavior research are attached. Set the number of rows and click Run, a table with
test data is generated(see Source_sql folder) and displayed for clarity. If I now initiate TSQLQuery.Last with DBNavigator, then
if the value is QtyRows=200000 on my computer with 32 gigabytes of memory, it will be exhausted within a few seconds and
the application will crash(see Screenshot_errors folder).

Same behavior for CT8.6, CT8.7 on Debian 12 and on Windows 10 (VirtualBox).

Best regards

Tested TSQLQuery on CT 8.3 with fairly large SQLite table and no problems found

Please,
give us time to test and report here

From CT 8.3 to CT 8.6 and CT 8.7 sqlite3conn.pp has some changes.

The problem is in your qCreateTable.SQL
CHAR(xx) Don't work and give "memo" field 65.0000 bytes.

The solution is to replace ALL CHAR(XX) with VARCHAR(XX) in your qCreateTable.SQL.

The attach file newsql.zip, has the correct SQL for qCreateTable.SQL, and request only 257 Mbytes from your project.


 
 

Thank you for your support and exit from the impasse!
Code Typhon is a reliable tool! Great job, guys!

Best regards