Re: [opendbx] slow insert with sqlite
Brought to you by:
nose
From: Norbert S. <no...@li...> - 2011-07-05 20:59:25
|
Hi Alain > I've done a small program in Pharo 1.3 with glorp+opendbx that insert 1000 > rows in a customer table in a sqlite db. > The 1000 insert takes 140 sec (very slow), but the Pharo profiler says that > it spend 95% of the time waiting for input. I can't speak for the Pharo implementation but SQLite is known for being problematic when at least two threads trying to write to the same database file. Norbert |