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 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. > > 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
