Hi Angela, for every iteration of your while loop a new transaction is opened and commited. You need to wrap the loop in manual transactions using BEGIN and COMMIT statements. Creating transaction logs is an expensive operation, when compared to the insert itself.
Regards, Michael -----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. 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 command." (http://www.sqlite.org/lang_transaction.html) My program executes only three queries: 1. create table contacts ... 2. "insert into contacts values (?, ?, ?, ?, ?, ?, ?, ?, ?);" 3. "create index idx_last_name on contacts (lastName ASC)" The second query is run in a while loop (about 200.000 times). > 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 Windows XP inserting one line into the database >> takes about 16 milliseconds. On a machine with Windows Server 2003 >> inserting the same line takes 150 to 200 milliseconds. I execute the same jar-file and use exactly the same data on both machines. >> >> Where might this big difference come from? >> >> Thank you for your answers in advance! >> Best regards _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
