Hi Alexey, I thought I answered to those questions but once again : * my application runs on an embedded device (Honeywell 9900) , it's a very complex application (too much I think) and we are facing performance problems while inserting datas (about 500 objects to be inserted inducing about 2000 queries and the same amount of transactions because the application runs with NON EXCLUSIVE flag, using serializable default isolation level). As any application running on an embedded device it 's not well suited for multi users!!! The application stores data for ONE employee of the company (our customers)... We have indexes (too much I think) but as far as I know in our case indexing is one performance problem rather than a solution (indexing in an INSERT phase adds overheads..)
But now my initial problem is solved , it was a problem with Xerial JDBC classes , sqlite manages well group of PRAGMA (where Xerial SQLiteConfig objects don't).... I'd like to use this post to thank you because I did not see such a good group for a while , with people reacting quickly and with a lot of value added comments....... So thank you guys ,keep this very special Open Source mind alive for a while I just post an entry on my blogger.com page.. For those interested : http://romjethoughts.blogspot.com/2011/09/sqlite-performance-tuning.html kind regards Jerome _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
