Hi list,
I'm trying to get sqlite to utilize the pagecache and scratch buffers.
But when the code exits it returns pagecache overflow and scratch buffer
overflow .
The to configure the pagecache and scratch are done in the main section of
code as follows:
Then connections to sqlite are made in other threads.
sqlite3_initialize() ;
sqlite3_config(SQLITE_CONFIG_MEMSTATUS, 1 );
sqlite3_config(SQLITE_CONFIG_LOOKASIDE, 64, 64 );
sz = 8 * pgSz ;
pBuf = malloc ( (sz * threads) + 2048 ) ;
if ( pBuf != NULL) {
sqlite3_config(SQLITE_CONFIG_SCRATCH,pBuf, sz, threads);
}
if (pgCache > 0 && pgSz == 4096) {
npgSz = 4368 ; // Divisible by 16
sz = npgSz * pgCache ;
pBuf = malloc(sz) ;
if ( pBuf != NULL) {
sqlite3_config(SQLITE_CONFIG_PAGECACHE,pBuf, npgSz, pgCache );
}
}
Any ideas why the pagecache or scratch is not utilized at all ?
Thanks,
Ken
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
