[opendbx] slow insert with sqlite
Brought to you by:
nose
From: Alain R. <al...@fr...> - 2011-07-05 20:47:10
|
Hi, (sorry for sending this mail again, my pc was off for a long time and the message was dated from 2007, people who sort their messages would not see it) 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. (in InputEventPollingFetcher>> waitForInput) I was wondering if the queries are executed in another thread than the vm thread ? (I thought I've seen a document about opendbx architecture but could'nt find it on the site). TIA Alain |