SQLITE memory crash

[espositophp]

Hello, I am in hot water using SQLITE.

My film database is now more than 70 megabytes big and when I run the statement

sl3tb := sl3db.GetTable('SELECT * FROM film');

it gives me an error message telling me there's a memory overflow.

So, I think I should sort out the problem by limiting the range of records satisfying the query. For example, I could use

sl3tb := sl3db.GetTable('SELECT * FROM film WHERE ID < 50');

Nevertheless, when I have to move to the last record, I am forced to select the rows from start to finish and, on doing so, my app crashes.

What am I missing?

Thanks in advance for your help.

 

[whosrdaddy]

a 70Meg table should not give any problems.
could be related to the components you are using (or even the sqllite client driver). did you check their form/website for this issue?

-----------------------------------------------------
What You See Is What You Get
Never underestimate tha powah of tha google!

 

[espositophp]

Thank you very much indeed for your reply.

You can download the original Delphi source code I have used clicking on this link:

http://www.espositosoftware.it/sqlite_db.zip

Please consider that my app works just fine with a small quantity of records, but when the DB size increases, you get an error message informing you that the memory is insufficient.

The error is triggered by the following code:

sl3tb := sl3db.GetTable('SELECT * FROM password');

Any help will be greatly appreciated.