[EMAIL PROTECTED] wrote: > I'm new to SQLite and have been reading the archives for background. > > Are there a common set of pragmas that a new developer should master and > if so which ones do you recommend I focus on? > > Is there a 'best practice' standard set of pragmas that apply to most > applications?
Much care and thought have gone into setting up the default behaviors in SQLite. My advice would be not to use any pragmas initially. If you find that you need better performance or different behavior, start tweaking then. Of course, you will need to read through the documentation a few times to be aware of the possibilities. (It sounds as if you have been doing this already, and should be in good shape.) To rephrase, the standard set of pragmas is the empty set. SQLite "just works." Good luck, Gerry _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
