Xojo Conferences

« Merry Christmas | Home | New special constants… »

SQLite Benchmark

Had some spare time today and tweaked the SQL plugin for SQLite a little bit, so the benchmark now looks much better:

Now our plugin is definitively faster :-)
26 12 13 - 22:44
five comments

How many rows? Code? Or better project? Are you using transactions or do you commit after each insert?
Markus Wnter (Email) - 27 12 13 - 12:54

as you see 1 million rows. The benchmark project is included already with the examples and we commit for the insert on the end. Just a little bit of tuning makes the plugin much faster than it used to be.
Christian Schmitz (URL) - 27 12 13 - 13:43

Looks fantastic :-) Are you using the SQLConnectionMBS or the SQLDatabaseMBS interface for the tests?
Kim Sandholt (Email) - 28 12 13 - 14:03

Hi Christian, please make a new SQL Plugin download available with the updated Benchmark sample project. The current download contains the old project.
Kim Sandholt (Email) - 30 12 13 - 17:50

Of course, this will be included in 14.0pr1 plugins.
Christian Schmitz (URL) - 30 12 13 - 18:29

Remember personal info?

Emoticons / Textile

Hide email:

Small print: All html tags except <b> and <i> will be removed from your comment. You can make links by just typing the url or mail-address.