Samuel, Each one attached database has its own page cache with 2000 (default number of pages in cache) * 1024 (default size in bytes of a page), totaling 2 Mb of ram. But you can define the number of pages in cache. I work using 5 attached databases this needs 10Mb, but some devices (PalmOS) has only 2.5 Mb!!! And I resolve using the SQL command 'PRAGMA [DB_ALIAS].cache_size = [NEW_CACHE_SIZE]'.
P.S. 2000 is maximum number of pages cached, not used at all instantly on attach. ----- Mensagem original ----- De: "a1rex" <a1rex2...@yahoo.com> Para: sqlite-users@sqlite.org Enviadas: Quarta-feira, 17 de Fevereiro de 2010 16:38:27 (GMT-0300) Auto-Detected Assunto: [sqlite] Memory usage – one data base versus two smaller ones For some reasons it is more convenient for the project to have a few smaller databases with unrelated data than one containing everything. My only concern is RAM memory. How much burden/memory overhead an additional database would introduce? Thank you for your input, Samuel __________________________________________________________________ Ask a question on any topic and get answers from real people. Go to Yahoo! Answers and share what you know at http://ca.answers.yahoo.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Israel Lins Albuquerque Desenvolvimento Polibrás Brasil Software Ltda. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
