Re: [sqlite] One data base versus two smaller ones

Thank you for putting me on the right track! Now I know how to attack the issue. Also this pragmas may help me: PRAGMA default_cache_size = Number-of-pages; PRAGMA cache_size = Number-of-pages; PRAGMA page_size = bytes; PRAGMA max_page_count = N; Regards, Samuel - Original Message Fr

Re: [sqlite] One data base versus two smaller ones

On Fri, Feb 19, 2010 at 07:57:15AM -0800, a1rex scratched on the wall: > Thank you very much for your help! > > Since my typical record is less than 100 bytes I guess that I can use > Page Size = 512 bytes without degradation of database performance. Leaf pages hold more than one record. I su

Re: [sqlite] One data base versus two smaller ones

- De: "a1rex" Para: j...@kreibi.ch, "General Discussion of SQLite Database" Enviadas: Sexta-feira, 19 de Fevereiro de 2010 12:57:15 (GMT-0300) Auto-Detected Assunto: Re: [sqlite] One data base versus two smaller ones Thank you very much for your help! Since my t

Re: [sqlite] One data base versus two smaller ones

Thank you very much for your help! Since my typical record is less than 100 bytes I guess that I can use Page Size = 512 bytes without degradation of database performance.This would conserve memory. How vital is default number of pages for database performance? Can I drastically drop the num