Hi Gerry, > Much care and thought have gone into setting up the default behaviors in > SQLite. > My advice would be not to use any pragmas initially.
That may be the safe solution, but my impression was that SQLite defaults to conservative settings that may not apply to many of today's high RAM workstations. Since I asked my question, I came across the following article that suggests 4 common pragma opportunities for optimization. The article is from 2006 so I don't know if its advice still applies to the current version of SQLite. http://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.html#pragmas Regards, Malcolm _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
