Sqlite and performances in LiveCode

Jérôme Rosat jrosat at mac.com
Sat Mar 3 18:00:55 EST 2012


Hi all,

I have to create a small application to access an SQLite database.

This database contains approximately 150,000 records and it increases by about 5,000 records per month.

Before beginning, I read the lesson "Displaying Large Amounts of Data" on the site of RunRev and I did tests with the sample stack and database (50'000 records).

I was surprised by the performance of LiveCode. When I use the stack (or the standalone app, the query of all the records takes about 932 milliseconds. But when I use SQLiteManager (an app that I use to manage sqlite files)  with the same table, at the same place, the query of all the records takes about 194 milliseconds.

Does LiveCode is less efficient to query databases than others development tools? Do you have any ideas to improve performance?

Thank you for your feedback.

Jérôme



More information about the use-livecode mailing list