Hi once again I will answer to these questions (most of them) J.MOLIERE - Mentor/J auteur Eyrolles
2011/9/6 Alexey Pechnikov <pechni...@mobigroup.ru>: > Jerome, can you show your database structure and queries? no definetely not I can't for legal reasons..sorry > Which FS is used? the only one available on Windows Mobile 6.5...... internal flash disk is used for storage because there 's no SD card available on the devices as bought by our customers Did you set corresponding pragmas > page_size, cache_size, journal_mode? page_size yes cache_size no because we are using a higher level cache (in Java) journal_mode is in the list of the pragmas to be tested through the benchmark ....setting this parameter to OFF speeds up transactions for around 20% Indicies can be very > slow... may be the FTS4 table will be much faster for your queries. can you give more details about this concept ? what is the FTS4 table ? I am sorry don't know what is is !!! > Do you use a prepared queries?.. yes of course we do Which type of storage are you > use? internal flash disk Can you group a set of inserts into single transaction? yes I previously refactored part of this code to do such job, I divided by 4 responses times ... But in the meanwhile customers requested changes and we added other inserts/selects... > Did you try to use in-memory database as temp storage and > copy set of records into main database in single transaction? it's one of the goal of the benchmark but this solution has av ery high level of database corruption isn't it ..so I prefer to keep it as a joker... > There are a lot of questions without answers. > thanks once gain _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
