Hello,
I am testing the query rate for an SQLite database (DB) that has a table with 100 Million rows. The DB file size is 9.7 GiB and I am running it on a Dell Server that has 128 GiB of RAM available. The sqlite cache_size pragma is set to 64 GiB before I start querying so the entire DB contents will fit into memory. I am performing the queries through a Python script that uses the sqlite3 module. For my test, I am measuring the query rate over time where query rate is determined by number of queries completed / elapsed time. I would like to include the size of the cache to determine how much of the DB has been loaded into the SQLite internal cache at each measurement point. Is there an SQLite command to determine the effective cache_size, or how much of the cache is currently being used? I haven't seen any solutions for using the Python sqlite module. I also haven't seen any solutions for determining the cache size for SQLite for the interactive command line. Also, is there an SQLite command (other than querying all rows) to pre load the DB or index into the cache? Any guidance would be appreciated. Thanks, Kristina _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
