Sqlite and performances in LiveCode

[Jérôme Rosat]

Thank you Kay for your feedback.

I didn't realize that SQLiteManager was "the King of the speed" and I am reassured to see that LiveCode is not so slow compared to other tools.

Le 5 mars 2012 à 07:22, Kay C Lan a écrit :

> No, it's not the same one.
> 
> Looking at the SQLabs site, SQLabs "developed from scratch a brand new
> ListBox that is able to display an infinite number of rows and columns in
> just few milliseconds. This is a fundamental base control for the app."
> They've been optemising their product since 2003, it would be surprising if
> you can match them on your first try.
> 
> I did a few tests with FireFox's SQLite Manager and for 50,000 records
> (11MB) it took 504ms to display in a field that could display ALL records.
> 
> Testing with LC I could extract the same records in 409ms but to display
> them all in a field took it out to 917ms. By reducing the number of records
> displayed to the size of the field, it took 410ms. Clearly LC fields are
> the limiting factor here.
> 
> I then noticed that in FireFox, although all the rows could be scrolled
> down to the bottom, the columns were all truncated. So I then changed my LC
> field to a 'Basic table object', set the 'Maximum editable columns' to
> match exactly the number of columns I had, and then set the tab stops so
> only a small portion of data of each column was displayed - similar to how
> FireFox truncated it's columns. In this way I was able to display ALL the
> rows in 491 ms.
> 
> This may not be as fast as SQLabs, but I think they maybe the speed kings.
> Compared to another SQLite tool I was able to get LC to perform just as
> fast, if  not a little faster.
> 
> HTH
> 
> 
> On Sun, Mar 4, 2012 at 7:12 PM, Jérôme Rosat <jrosat at mac.com> wrote:
> 
>> I don't know if SQLiteManager for Firefox is the same one I use (from
>> SQLabs) but it display all the records in one time (I can scroll all the
>> list).
>> 
>> But thank you for the suggestion, If necessary I'm going to display only a
>> part of the records with a next button, even if I don't like very much this
>> approach.
>> 
>> 
>> Le 4 mars 2012 à 03:37, Kay C Lan a écrit :
>> 
>> 
>>> If the 'SQLiteManager' you refer to is the same one I use with FireFox,
>> in
>>> my case it only displays 100 records at a time, you have to click the
>> Next
>>> button to see more - so this is a performance trick you can do with LC.
>>> Instead of extracting 150000 records in one go, and displaying it in a
>>> field in one go( which will take a long time) only extract 100 records
>>> (which will take significantly less time) and have a Next button, just
>> like
>>> SQLIte Manager, to retrieve the next 100 records.
>>> 
>>> If I'm right, the the fact that LC only took 4.4 times longer to display
>>> 1500 times more records would suggest that you'll be able to do a lot
>>> better with LC
>>> 
>>> HTH
>>> _______________________________________________
>>> 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
>> 
>> 
>> _______________________________________________
>> 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
>> 
> _______________________________________________
> 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