From e36d23a85ebff914d74bb541558c2b6082b78edb Mon Sep 17 00:00:00 2001
From: dan miller
Date: Sat, 20 Oct 2007 02:49:29 +0000
Subject: sqlite source (unix build) added to libraries

---
 libraries/sqlite/unix/sqlite-3.5.1/www/optimizing.tcl | 15 +++++++++++++++
 1 file changed, 15 insertions(+)
 create mode 100644 libraries/sqlite/unix/sqlite-3.5.1/www/optimizing.tcl

(limited to 'libraries/sqlite/unix/sqlite-3.5.1/www/optimizing.tcl')

diff --git a/libraries/sqlite/unix/sqlite-3.5.1/www/optimizing.tcl b/libraries/sqlite/unix/sqlite-3.5.1/www/optimizing.tcl
new file mode 100644
index 0000000..44d2825
--- /dev/null
+++ b/libraries/sqlite/unix/sqlite-3.5.1/www/optimizing.tcl
@@ -0,0 +1,15 @@
+set rcsid {$Id: optimizing.tcl,v 1.1 2005/01/17 03:42:52 drh Exp $}
+source common.tcl
+header {Hints For Optimizing Queries In SQLite}
+proc section {level tag name} {
+  incr level
+  if {$level>6} {set level 6}
+  puts "\n"<a name=\"tag\" />"
+  puts "<h$level>$name</h$level>\n"
+}
+section 1 recompile {Recompile the library for optimal performance}
+section 2 avoidtrans {Minimize the number of transactions}
+section 3 usebind {Use sqlite3_bind to insert large chunks of data}
+section 4 useindices {Use appropriate indices}
+section 5 recordjoin {Reorder the tables in a join}
+footer $rcsid
-- 
cgit v1.1