Hi everyone,

I'm newbie in SQLite,  I need some advice how to set/create a 
good speed with SQLite.

On situation will be as follow,
  a) one database with 2 tables.
  b) 4 threads access to this database just for SELECT statement

Question, 
  a) do I create 1 handle of SQLite_Open or manys
  b) what was the best chace size, if the file size about 300K
  c) how do I create a cache to hold only 1 physical memory to fit
      all the database's table

Thx in advance.

Regards
KL Chin 

 


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to