[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 re

[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 read

[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 ht

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

, smallboat wrote: > Hi, > > > I am using  sqlite_status = > sqlite3_status(SQLITE_STATUS_MEMORY_USED,&pCurrent,&pHighwater, resetFlag); > to get the memory used by sqlite. > > > What is the memory unit for pCurrent (the max sqlite memory used)? > > Is i

[sqlite] what is the unit of SQLITE_STATUS_MEMORY_USED?

Hi, I am using   sqlite_status = sqlite3_status(SQLITE_STATUS_MEMORY_USED, &pCurrent, &pHighwater, 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 ___