On 10/10/06, Lloyd <[EMAIL PROTECTED]> wrote:
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?
Are you doing these insertions in a transaction?
--
> 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
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
3 matches
Mail list logo
