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] -----------------------------------------------------------------------------
