Hello everybody, First of all thx for your help. Now my inserts goes much faster at the beginning but now it is going slow again but I know why :) I set autocommit to false, use prepareStatement and batched every 100 000 and at beginning when the table is empty i get 1500 entries per second but now that the table has over 2.5million entries it grow down to 25entries per second. So the speed has also to do with the content of the database.
So I decided to splitt my table in 31 tables for each day one, there the entries are all day 1500entries/seconds and sometimes more but this solutions gives my now an other problem for doing some queries. Because when it was just in 1 table the insert took very long but the executation of my query simple select field from table limit 100 and so on was very fast +-50ms. Now that I have 31 tables i did a view where i group the tables together with UNION and when i make the same query on that view it takes 4minutes. Does somebody have an idea to get this again on the same speed? --~--~---------~--~----~------------~-------~--~----~ Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en To unsubscribe, send email to [EMAIL PROTECTED] -~----------~----~----~----~------~----~------~--~---
