cvs: docweb /scripts notes_stats.php

nlopess Fri Mar 25 11:48:08 2005 EDT Modified files: /docweb/scripts notes_stats.php Log: adding transactions to highly improve performance remove the primary key and associated tricks #testing in a moment... http://cvs.php.net/diff.php/docweb/scripts/notes_stats.php?r1=1.7&r2=1.8&ty=u Index: docweb/scripts/notes_stats.php diff -u docweb/scripts/notes_stats.php:1.7 docweb/scripts/notes_stats.php:1.8 --- docweb/scripts/notes_stats.php:1.7 Wed Feb 9 13:26:09 2005 +++ docweb/scripts/notes_stats.php Fri Mar 25 11:48:06 2005 @@ -17,7 +17,7 @@ | Vincent Gevers <vincent@php.net> | | Credits: Sean Coates <sean@php.net> | +----------------------------------------------------------------------+ -$Id: notes_stats.php,v 1.7 2005/02/09 18:26:09 nlopess Exp $ +$Id: notes_stats.php,v 1.8 2005/03/25 16:48:06 nlopess Exp $ */ require_once '../build-ops.php'; @@ -97,7 +97,9 @@ // using $i to allow a fetching resume $sql .= "UPDATE info SET last_article=$i, build_date=$last_update;"; +sqlite_query($sqlite, 'BEGIN TRANSACTION'); sqlite_query($sqlite, $sql); +sqlite_query($sqlite, 'COMMIT TRANSACTION'); sqlite_close($sqlite); @@ -157,7 +159,7 @@ ); CREATE TABLE notes ( - note INTEGER PRIMARY KEY, + note INTEGER, action TEXT, manpage TEXT, who TEXT, @@ -175,7 +177,7 @@ /* makes a sql insert statment from an array */ function make_sql($array) { array_shift($array); - return 'INSERT OR IGNORE INTO notes VALUES ("' . implode('", "', $array) . '");'; + return 'INSERT INTO notes VALUES ("' . implode('", "', $array) . '");'; } ?>