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