diff options
| author | dan miller | 2007-10-20 02:49:29 +0000 |
|---|---|---|
| committer | dan miller | 2007-10-20 02:49:29 +0000 |
| commit | e36d23a85ebff914d74bb541558c2b6082b78edb (patch) | |
| tree | 54b58fdf162e78af64055282a6035c8d2443389d /libraries/sqlite/unix/sqlite-3.5.1/www/optimizing.tcl | |
| parent | * Fixed an issue whereby avatar chat distances were being calculated against ... (diff) | |
| download | opensim-SC-e36d23a85ebff914d74bb541558c2b6082b78edb.zip opensim-SC-e36d23a85ebff914d74bb541558c2b6082b78edb.tar.gz opensim-SC-e36d23a85ebff914d74bb541558c2b6082b78edb.tar.bz2 opensim-SC-e36d23a85ebff914d74bb541558c2b6082b78edb.tar.xz | |
sqlite source (unix build) added to libraries
Diffstat (limited to 'libraries/sqlite/unix/sqlite-3.5.1/www/optimizing.tcl')
| -rw-r--r-- | libraries/sqlite/unix/sqlite-3.5.1/www/optimizing.tcl | 15 |
1 files changed, 15 insertions, 0 deletions
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 @@ | |||
| 1 | set rcsid {$Id: optimizing.tcl,v 1.1 2005/01/17 03:42:52 drh Exp $} | ||
| 2 | source common.tcl | ||
| 3 | header {Hints For Optimizing Queries In SQLite} | ||
| 4 | proc section {level tag name} { | ||
| 5 | incr level | ||
| 6 | if {$level>6} {set level 6} | ||
| 7 | puts "\n"<a name=\"tag\" />" | ||
| 8 | puts "<h$level>$name</h$level>\n" | ||
| 9 | } | ||
| 10 | section 1 recompile {Recompile the library for optimal performance} | ||
| 11 | section 2 avoidtrans {Minimize the number of transactions} | ||
| 12 | section 3 usebind {Use sqlite3_bind to insert large chunks of data} | ||
| 13 | section 4 useindices {Use appropriate indices} | ||
| 14 | section 5 recordjoin {Reorder the tables in a join} | ||
| 15 | footer $rcsid | ||