Hi Bob, Den 18 maj 2017 9:15 em skrev "Bob Friesenhahn" < bfrie...@simple.dallas.tx.us>:
On Thu, 18 May 2017, Kim Gräsman wrote: > >> The request is issued early on when the connection is first opened so no >> actual queries have been issued at that time. >> > > Then my (black-box) guess is that you're seeing the bump from > allocating heap space for whatever structures the schema needs. > Our schema takes a bit over 1MB to load on a 32-bit CPU. The increased usage we are seeing is on the order of 200k so it is not the schema. Regardless, the application is using the database immediately so it must always consume the schema. Well, when you run pragma cache_size before any other queries, it *will* load the schema. So unless you are also seeing a 1MB bump besides the 200K, it must be schema data. Maybe it occupies less memory than you've estimated? Perhaps the SQLite devs can think of a way to diagnose this more exactly. - Kim _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
