mORMot Open Source

Roberto Schneiders

Member

From: Santa Catarina, Brazil

Registered: 2012-09-19

Posts: 127

Website

Performance problems with SQLite

I ran the performance tests (15 - External DB performance) with Delphi XE4 on my machine and I had very different (Insertion speed) results from yours. Can you help identify why?

Basis for comparison (AB Notebook).

Direct              Batch  Trans  Batch   Trans
SQLite3 (file full)  493    494   88284   108877
SQLite3 (file off)   923    908   93613   117952
SQLite3 (ext full)   498    504  101296   128885
SQLite3 (ext off)    966    930   83708   108700

My PC (SSD)

Direct              Batch Trans  Batch   Trans
SQLite3 (file full)   83     91  53851   67388
SQLite3 (file off)  1886   2053 108731  143282
SQLite3 (ext full)    99     87  70905   60120
SQLite3 (ext off)   2225   2303 125966  164235

My PC (HD)

Direct              Batch  Trans  Batch   Trans
SQLite3 (file full)     7     7   19804   20062
SQLite3 (file off)   2500  1841  112115  141330
SQLite3 (ext full)      6     6   17333   21157
SQLite3 (ext off)    2497  2138  123499  159877

Hardware configuration

Intel Core i7 3770 3.4Ghz (4Cores/8Threads)
SSD 120Gb Sandisk
HD Seagate Barracuda 7200
8Gb Ram DDR3

I disabled the antivirus.

What worries me more are the smFull tests.

Last edited by Roberto Schneiders (2013-07-26 13:32:47)

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,655

Website

Re: Performance problems with SQLite

There was a problem in the source code: the exclusive mode was sometimes enabled when file was off.

In the latest commits, I disabled it.
This was confusing the tests.

I will re-run the tests to see what are the new values.

Roberto Schneiders

Member

From: Santa Catarina, Brazil

Registered: 2012-09-19

Posts: 127

Website

Re: Performance problems with SQLite

I'll wait for the new results.