Yes, 6-20 ms is perhaps a lot for a single insert. Note: if I do 1000 inserts inside a BEGIN/COMMIT, it tooks me only 50-80 ms.
So I think the main part of time is spent on I/O operations. [EMAIL PROTECTED] a écrit : > Thanks for your fast answers. > > I tried on a different machine and it was still around 80ms for native > drivers and it threw OutOfMemoryException for the nested driver. Even > 6-20ms is alot for a single insert don't you think? One insert into a > database shouldn't take more than 1 ms when the connection to the > database is already open. > > On Mar 20, 2:11 pm, Xavier RAYNAUD <[EMAIL PROTECTED]> wrote: > >> I tried your application on my linux workstation: >> I obtain insert time between 6 and 20 ms. >> Perhaps the problem is elsewhere ? >> >> Xavier >> > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "SQLiteJDBC" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlitejdbc?hl=en -~----------~----~----~----~------~----~------~--~---
