*** 8,13 ****
--- 8,18 ----
These mostly relate to Windows and Delphi environments but may help others, and refers to SQLite 3.1.0:
+ **Zero: (optional) Set Windows Caching**
+
+ If you have the RAM to spare and you are using very large database, then this optional Windows setting will dramtically improve SQLite performance using temporary tables (sorting, group by, subselects, etc):
+
+ {link: http://marc.theaimsgroup.com/?l=sqlite-users&m=116743785223905&w=2 Setting Windows Temporary File Cache}
**One: Talk to the SQLite directly**
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|