sqlite - Performance Tuning

Not logged in

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

• Contents
• No-Diff
• Text

*** 27,33 ****
  WHERE clauses in your SQL statements will eliminate this step and thus speed
  up the compilation of the SQL. This is probably true, but the savings will
  be quite miniscule. Perhaps around 2 or 3
! malloc()/free() calls per JOIN clause. PreCompiledSql might be a better trick.
  </P>
  
  <H2>Order your tables properly in your where clause</H2>
--- 27,33 ----
  WHERE clauses in your SQL statements will eliminate this step and thus speed
  up the compilation of the SQL. This is probably true, but the savings will
  be quite miniscule. Perhaps around 2 or 3
! malloc()/free() calls per JOIN clause. <a href="http://www.sqlite.org/cvstrac/wiki?p=PrecompiledSql">PrecompiledSql</a> might be a better trick.
  </P>
  
  <H2>Order your tables properly in your where clause</H2>