Dear experts, I have compiled sqlite-autoconf-3070500 on a RedHat Linux machine. My application is written in C, so uses the SQLite C interface.
At startup I connect to an admin datafile, and then attach 20 more datafiles to the connection. After creating the initial connection (before attaching to the other datafiles), I issue "PRAGMA cache_size=1048576". If I query the cache size with "PRAGMA cache_size", the correct value is returned. However, this appears to have no actual effect on the application. As I proceed to insert data randomly into the 20 attached datafiles, the application's memory footprint is capped at 64 MB, even though the combined size of the datafiles is well over 400 MB. As a test I recompiled SQLite with -DSQLITE_DEFAULT_CACHE_SIZE=1048576. Without issuing the PRAGMA, the memory (cache) size now continues to grow to match the size of the datafiles as expected. Has any of you encountered this problem before? Am I doing something wrong, or could there be a problem with this release of SQLite? Any ideas or comments will be much appreciated. Regards, Jaco _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
