Hello As usual, there is no general rule. You have to define the best settings for your embedded environement yourself.
Start here: "[sqlite] Performance tuning using PRAGMA, other methods" http://www.mail-archive.com/sqlite-users@sqlite.org/msg29343.html Try different settings to get the feeling which PRAGMAs are critical for you. Daniel _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users