> >On 4/18/07, Samuel R. Neff <[EMAIL PROTECTED]> wrote: >> >>cache is per-connection so if you open and close connections a lot then a >>large cache won't help your program. The command line app is a single >>connection so a large cache there will help (although not with the first >>queries--only subsequent ones). >> >>Synchronous off is dangerous. Search the history for details. >> >>Sam
If you are under windows you can set pragma CACHE_SIZE to default and try this: System Properties > Advanced Properties > Efficiency > Advanced Options > Memory Use set it to System Cache. This way the system disk cache get more (nearly all) memory. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
