Sqlite and performances in LiveCode

[Jérôme Rosat]

Trevor,

I use the stack provided here: http://www.bluemangolearning.com/download/revolution/tools/datagrid_databases.zip

I don't know if I understand your question, but the code is:

    put the milliseconds into theStart
    put revQueryDatabase(sConnID,"SELECT * FROM movies") into sCursorID
    put the milliseconds - theStart into theDuration
    Log "Opening movies cursor took" && theDuration && "milliseconds" 

There is only one call "revQueryDatabase".

Le 5 mars 2012 à 20:00, Trevor DeVore a écrit :

> 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
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode