Re: [sqlite] Fine tuning of Sqlite

2011/9/6 Alexey Pechnikov : > 2011/9/6 jerome moliere : >> Could you give me more  details about corruption cases ? >> Is there a list of contexts where we can get corrupted tables ? > > http://www.sqlite.org/howtocorrupt.html Just one word :

Re: [sqlite] Fine tuning of Sqlite

2011/9/6 jerome moliere : > Could you give me more  details about corruption cases ? > Is there a list of contexts where we can get corrupted tables ? http://www.sqlite.org/howtocorrupt.html -- Best regards, Alexey Pechnikov. http://pechnikov.tel/

Re: [sqlite] Fine tuning of Sqlite

>> 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 !!! > > See > http://www.sqlite.org/fts3.html > The full-text index is very fast and

Re: [sqlite] Fine tuning of Sqlite

2011/9/6 jerome moliere : >  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

Re: [sqlite] Fine tuning of Sqlite

Hi once again I will answer to these questions (most of them) J.MOLIERE - Mentor/J auteur Eyrolles 2011/9/6 Alexey Pechnikov : > 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

Re: [sqlite] Fine tuning of Sqlite

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

Re: [sqlite] Fine tuning of Sqlite

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

Re: [sqlite] Fine tuning of Sqlite

2011/9/2 Simon Slavin : > > On 2 Sep 2011, at 7:39am, jerome moliere wrote: > >> I must give some real clues to my customers to fine tune Sqlite > > 1) What problem(s) are you trying to solve ? > > 2) Must your system be set up for multi-process (or multi-user) access, or >

Re: [sqlite] Fine tuning of Sqlite

base <sqlite-users@sqlite.org> Subject: Re: [sqlite] Fine tuning of Sqlite >> Do you set of PRGAMAS uncompatible ? e;g: >> setting synchronous=true + journal_mode=off is a non sense for sqlite >> so engine can't deliver connections > > I think I now see what you wan

Re: [sqlite] Fine tuning of Sqlite

>> Do you set of PRGAMAS uncompatible ? e;g: >> setting synchronous=true + journal_mode=off is a non sense for sqlite >> so engine can't deliver connections > > I think I now see what you want: a table saying if you have PRAGMA A set to > THIS, then PRAGMA B has no effect. Personally I don't

Re: [sqlite] Fine tuning of Sqlite

Hi Simon, thanks for your answer comments below >> I want to setup a benchmark injecting different configurations of the >> sqlite engine and doing different queries (insert/select ) into >> different transactional contexts over dummy data.. >> For such job I need to inject different

Re: [sqlite] Fine tuning of Sqlite

On 2 Sep 2011, at 8:08am, jerome moliere wrote: > I want to setup a benchmark injecting different configurations of the > sqlite engine and doing different queries (insert/select ) into > different transactional contexts over dummy data.. > For such job I need to inject different PRAGMAs

Re: [sqlite] Fine tuning of Sqlite

I'll give you some elements regarding your questions but there 's no immediate link with my current problem... 2011/9/2 Simon Slavin : > > On 2 Sep 2011, at 7:39am, jerome moliere wrote: > >> I must give some real clues to my customers to fine tune Sqlite > > 1) What

Re: [sqlite] Fine tuning of Sqlite

Hi Simon, thanks for your reply but try to forget the general introduction of my context I want to setup a benchmark injecting different configurations of the sqlite engine and doing different queries (insert/select ) into different transactional contexts over dummy data.. For such job I

Re: [sqlite] Fine tuning of Sqlite

On 2 Sep 2011, at 7:39am, jerome moliere wrote: > I must give some real clues to my customers to fine tune Sqlite 1) What problem(s) are you trying to solve ? 2) Must your system be set up for multi-process (or multi-user) access, or can we ignore all problems concerning those ? 3) Are you

[sqlite] Fine tuning of Sqlite

Hi all sqlite users, I'm using Sqlite for an application using 150 Mb databases running on an embedded device (Honeywell Dolphin 9900) into an OSGi Java context. I must give some real clues to my customers to fine tune Sqlite, so I discovered among different ways to have better results PRAGMAs...