Sqlite and performances in LiveCode

Trevor DeVore lists at mangomultimedia.com
Mon Mar 5 14:00:26 EST 2012


On Sat, Mar 3, 2012 at 6:00 PM, Jérôme Rosat <jrosat at mac.com> wrote:

>
> 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.
>

Jérôme,

What are the exact calls you make in LiveCode during the 932 milliseconds?

-- 
Trevor DeVore
Blue Mango Learning Systems
www.clarify-it.com    -    www.screensteps.com



More information about the use-livecode mailing list