SQLite Optimization FAQ - The Diigo Meta page

• 13 Feb 14
  

  devartemz

  chrome Bookmarks Bar Android sqlite

• 02 Jan 13
  

  Matthew Plourde

  sqlite3 optimization

• 10 May 12
  

  Rico c

  sqlite sqlite_optimize

• 27 Sep 11
  

  florentin s

  sqlite

• 06 Apr 11
  

  wildlarva .

  from-delicious sqlite tips performance

• 04 Apr 11
  

  Doug Y'barbo

  SQLite PerformanceOptimization RDBMS Performance

• 23 Aug 10
  

  Chuck Horton

  sqlite3 adobeair

• 30 Jul 10
  

  Ben Bushoy

  sqlite database

• 23 Jun 10
  

  imoldcat
  • So the key to optimizing SQLite is to minimize the amount of disk access required.
  • Because operating systems generally cache open disk files in memory, a carefully tuned use of SQLite can approach the speed of a pure in-memory database.
  • If you are new to optimization, you must know that the only reliable way to optimize for speed is to measure where time is being spent.
  • Unfortunately, reproducibly measuring performance on an application that does disk access isn't trivial.
  • The Boolean synchronous value controls whether or not the library will wait for disk writes to be fully written to disk before continuing. This setting can be different from the default_synchronous value loaded from the database. In typical use the library may spend a lot of time just waiting on the file system. Setting "PRAGMA synchronous=OFF" can make a major speed difference.

  3 more annotations...

• 24 May 10
  

  Sachin Sharma

  SQLite Optimization FAQ

  sqlite

• 04 May 10
  

  SQLite Optimization Performance

• 30 Apr 10
  

  Kevin Manley

  sqlite optimization

• 19 Mar 10
  

  kdebisschop

  database optimization sqlite

• 10 Mar 10
  

  ahenobarbi

  programming performance development tips documentation howto tutorial database optimization tuning

• 27 Feb 10
  

  Brett Howell

  sqlite optimization regex

• 26 Aug 09
  

  Grzegorz Wierzowiecki

  sqlite3 performance

• 11 Jul 09
  

  netsuke87

  howto software reference programming optimization speed optimize cocoa sql dev database tutorial tips api documentation tuning faq sqlite databases development code performance db memory dev.sql rrper uni cs coms sqlite3 expensive query most queries

• 

  database reference sqlite

• 29 May 09
  

  optimize sql sqlite

• 07 May 09
  

  Lars Nielsen

  sql sqlite database R

• 20 Apr 09
  

  kixxtm

  sqlite database sql optimization programming tuning performance faq

• 02 Feb 09
  

  Ümit Aslan

  sqlite

• 23 Jan 09
  

  Keith Yang

  reference database performance optimize

• 16 Oct 08
  

  cullepm3
• 08 Oct 08
  

  Dario Varotto

  sqlite tutorial faq development

• 

  ck hart

  dev.sql database

• 08 Aug 08
  

  alfred westerveld

  sqlite database optimization tuning

• 30 Jun 08
  

  Alexandre Courbot

  sql sqlite optimization faq

• 22 Feb 08
  

  Pablo Escobar

  sqlite

• 07 May 07
  

  turky_

  database faq programming sqlite

• 25 Jan 07
  

  halirob

  sqlite

• 30 Dec 06
  

  Andrew Perry

  sqlite sql database tips faq

• 07 Nov 06
  

  Vishnu Gopal

  imported Interesting sqlite database sql optimization programming delicious_import

• 15 Sep 06
  

  Reichi Amo

  database sqlite

• 13 Sep 06
  

  Tomasz Skrynnyk

  sqlite

• 06 Aug 06
  

  maknir

  database db optimization sqlite tuning

• 25 Jul 06
  

  Zhe sto

  database imported delicious sqlite tuning

• 10 Dec 05
  

  Eamonn O'Brien-Strain

  database tutorial

• 12 Nov 05
  

  C K

  SQLite optimization is-a:FAQ SQL XML

• 18 Apr 05
  

  David Martland
• 24 Nov 04
  

  AA Barker

  code sql

• 23 Dec 96
  

  computational know legacybookmark delicious

Would you like to comment?

Join Diigo for a free account, or sign in if you are already a member.