Jerome, can you show your database structure and queries? Which FS is used? Did you set corresponding pragmas page_size, cache_size, journal_mode? Indicies can be very slow... may be the FTS4 table will be much faster for your queries. Do you use a prepared queries?.. Which type of storage are you use? Can you group a set of inserts into single transaction? Did you try to use in-memory database as temp storage and copy set of records into main database in single transaction? There are a lot of questions without answers.
2011/9/6 jerome moliere <jerome.moli...@gmail.com>: > 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 > -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
