> Are these inserts in 1 transaction or 1000? Yes it is in 1000 transactions.
For me consistancy, atomicity...(ACID) are not a problem. But the speed of operation is major constraint. How can I achieve speed in insertion cases like this? Thanks for your informative reply. Lloyd. On Tue, 2006-10-10 at 12:51 +0100, Martin Jenkins wrote: > Lloyd wrote: > > Where could be the problem? The insert query is executing only 1000 > > times. > > Are these inserts in 1 transaction or 1000? If the latter then it will > take a long time because sqlite has to wait 1000 times for the data to > be written to the disk. It's generally accepted that this takes about 2 > revs of the disk - 2000 revs at 7200rpm is about 20 seconds. > > Martin > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- ______________________________________ Scanned and protected by Email scanner ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------