Re: [sqlite] insert on windows server 2003 very slow

mailto:[EMAIL PROTECTED] Im Auftrag von Angela Kramer > Gesendet: Dienstag, 26. Februar 2008 10:29 > An: Eugene Wee > Cc: General Discussion of SQLite Database > Betreff: Re: [sqlite] insert on windows server 2003 very slow > > Hi Eugene, > > thank you for your reply. > &

Re: [sqlite] insert on windows server 2003 very slow

-Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Angela Kramer Gesendet: Dienstag, 26. Februar 2008 10:29 An: Eugene Wee Cc: General Discussion of SQLite Database Betreff: Re: [sqlite] insert on windows server 2003 very slow Hi Eugene, thank you for your reply

Re: [sqlite] insert on windows server 2003 very slow

Hi Eugene, thank you for your reply. Eugene Wee wrote: > Hi Angela, > > Did you wrap the inserts in a transaction? I do not start a transaction manually. However a transaction is probably started automatically. But: "Automatically started transactions are committed at the conclusion of the co

Re: [sqlite] insert on windows server 2003 very slow

Hi Angela, Did you wrap the inserts in a transaction? Regards, Eugene Wee Angela Kramer wrote: > Hi, > > I've written a java programm which reads data from a file and inserts > them into a sqlite database. In order to speed up this process I use > PreparedStatement. > > On a computer running

[sqlite] insert on windows server 2003 very slow

Hi, I've written a java programm which reads data from a file and inserts them into a sqlite database. In order to speed up this process I use PreparedStatement. On a computer running Windows XP inserting one line into the database takes about 16 milliseconds. On a machine with Windows Server