mORMot Open Source

miab3

Member

From: Poland

Registered: 2014-10-01

Posts: 188

Test slowdown (1.18.1190)

Arnaud,

SQLite drastically slowed down in writing (TestSQL3.exe, 15 - External DB performance)
It looks like it works in 'synchronous = FULL' mode?
(Delphi XE2-32).

Michal

Last edited by miab3 (2015-04-03 22:45:32)

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,662

Website

Re: Test slowdown (1.18.1190)

I just run the tests, without any performance problems under Delphi 7 and XE4:

Insertion speed (Delphi 7 numbers)

 			Direct	Batch	Trans	Batch Trans
SQLite3 (file full)	347	22253	75478	177216
SQLite3 (file off)	1611	79355	76874	196509
SQLite3 (file off exc)	23359	184897	78315	202979
SQLite3 (mem)		66065	220167	78896	220089
TObjectList (static)	244630	391297	251965	386279
TObjectList (virtual)	243084	391849	250237	371581
SQLite3 (ext full)	383	9010	91538	166500
SQLite3 (ext off)	2120	43129	94842	176916
SQLite3 (ext off exc)	33626	169096	95932	183479
SQLite3 (ext mem)	82030	195243	96923	202085
WinHTTP SQL3 (off exc)	3534	56751	3947	58076
Socket SQL3 (off exc)	6769	76283	8423	81794

miab3

Member

From: Poland

Registered: 2014-10-01

Posts: 188

Re: Test slowdown (1.18.1190)

Arnaud,

Maybe it was not a problem SQLite, but there was something wrong in TestSQL3.
It looks like that now (in 1.18.1197) is well.

Michal