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?
Hi All,
I am using wxSqlite to develop my application. I have an insert query
in my application. It adds a 16 seconds overhead to my application,
otherwise it executes in 20 seconds. (Now it needs 36 seconds!).
Where could be the problem? The insert query is executing only 1000
times.
Thanks,
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
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,