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