Unused memory is wasted memory. If you have unused memory then you bought something that you did not need.
The question I have however is: (a) Why do you have such a crapload of itty-bitty databases? It kind of defeats the whole purpose of having a database at all. (b) Why have you changed the page_size from the default? There are be reasons for doing this, what is yours? -- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> On Behalf >Of Philippe RIO >Sent: Sunday, 8 September, 2019 15:13 >To: sqlite-users@mailinglists.sqlite.org >Subject: Re: [sqlite] SQLITE and the memory > >I use the windows task manager to see how the memory is used > > >Opening the 256 tables : >sqlite3_open_v2(_lpszTbl,&hSqlite[__iTableNumber],SQLITE_OPEN_READWRITE|SQL >ITE_OPEN_FULLMUTEX,NULL); > > > > > >----- >-------- >Kenavo > >https://md5finder.blogspot.com/ >(Never be pleased, always improve) >-- >Sent from: http://sqlite.1065341.n5.nabble.com/ >_______________________________________________ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
