[sqlite] Enabling Shared-Cache Mode

Hi, I am emailing to ask how I can know if the shared cache is acutally working and how many shared cache is created for the process. In my embedded sqlite running inside a process, we want to have all read-only db connections to share same cache to reduce memory while there are multiple

[sqlite] Enabling Shared-Cache Mode

Hi, I am emailing to ask how I can know if the shared cache is acutally working and how many shared cache is created for the process. In my embedded sqlite running inside a process, we want to have all read-only db connections to share same cache to reduce memory while there are multiple

[sqlite] command line to get number of tables in sqlite

Hello, I have a sqlite file. I would like to open it and know how many tables in it. What is the command line to open a sqlite file and get to know how many tables in it? Thanks. Regards, Joe ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] what is the unit of SQLITE_STATUS_MEMORY_USED?

12/17/2011 06:16 AM, smallboat wrote: > Hi, > > > I am using  sqlite_status = > sqlite3_status(SQLITE_STATUS_MEMORY_USED,,, resetFlag); > to get the memory used by sqlite. > > > What is the memory unit for pCurrent (the max sqlite memory used)? > > Is it

[sqlite] what is the unit of SQLITE_STATUS_MEMORY_USED?

Hi, I am using   sqlite_status = sqlite3_status(SQLITE_STATUS_MEMORY_USED, , , resetFlag); to get the memory used by sqlite. What is the memory unit for pCurrent (the max sqlite memory used)? Is it in bytes, bit or something else? Thanks Joe