--- In [email protected], "handitan" <handi...@...> wrote: > > Alright fellas, > > Spill out the secret. > When I do the multiple-insertion simultaneously, those operations just > stopped and any new transaction-transaction op request is ignored. > > My idea so far is to put any new transaction-request in a queue if a > transaction is currently in the process, and then after that transaction is > finished then do the next transaction-request from the queue.
Doesn't SQLLite have any syntax like INSERT INTO MyTable (Field1, Field2) VALUES (Obj1Field1, Obj1Field2), (Obj2Field1, Obj2Field2), (Obj3Field1, Obj3Field2) ? This would actually make the multiple inserts simultaneously, rather than trying to multiple sql statements all intependently trying to be simultaneous. -Amy
