sqlite - Performance Tuning Windows

Not logged in

• Honeypot
• Browse
• Home
• Login
• Reports
• Search
• Ticket
• Timeline
• Wiki

• Contents
• No-Diff
• Text

*** 10,16 ****
  
  **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}
    {link: http://support.microsoft.com/kb/895932}
--- 10,16 ----
  
  **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 dramatically 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}
    {link: http://support.microsoft.com/kb/895932}