I am finding it hard which is the best configuration for most of the large scale application. Our database size grows from 0 – 45 GB . As the database size grows, performance seems to be degrading. Performance of the same application is better when it compared to Sql Server.
I am in the middle of identifying the bottle neck and first thing I am looking for is the configuration. Current settings: PRAGMA journal_mode = TRUNCATE PRAGMA page_size;", lPageSize) UINT64 ui64MaxPageCount = 53687091200 / lPageSize; PRAGMA max_page_count = %I64u;", ui64MaxPageCount)); I am planning to change to below settings to see if that improves the performance. PRAGMA journal_mode = WAL PRAGMA page_size=4096 PRAGMA cache_size=16384 PRAGMA synchronous=NORMAL PRAGMA wal_autocheckpoint=100000 Setting wal_autocheckpoint to 100000 mean that the data gets committed to the disk after it reaches 100 MB , Am I right ? If the machine crashes or power goes off during this time, 100 MB data is lost? Any API calls which would commit the data to disk forcibly? Let me know if the above settings would improve the application performance or something needs to be configured. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
