cvs: php-src /ext/sqlite sess_sqlite.c

sterling Tue Jul 1 23:12:06 2003 EDT Modified files: /php-src/ext/sqlite sess_sqlite.c Log: further improve the performance and clean up Index: php-src/ext/sqlite/sess_sqlite.c diff -u php-src/ext/sqlite/sess_sqlite.c:1.8 php-src/ext/sqlite/sess_sqlite.c:1.9 --- php-src/ext/sqlite/sess_sqlite.c:1.8 Tue Jul 1 20:56:32 2003 +++ php-src/ext/sqlite/sess_sqlite.c Tue Jul 1 23:12:06 2003 @@ -17,7 +17,7 @@ +----------------------------------------------------------------------+ */ -/* $Id: sess_sqlite.c,v 1.8 2003/07/02 00:56:32 sterling Exp $ */ +/* $Id: sess_sqlite.c,v 1.9 2003/07/02 03:12:06 sterling Exp $ */ #include "php.h" @@ -44,7 +44,8 @@ /* TODO: do we need a safe_mode check here? */ db = sqlite_open(save_path, 0666, &errmsg); if (db == NULL) { - php_error_docref(NULL TSRMLS_CC, E_WARNING, "SQLite: failed to open/create session database `%s' - %s", save_path, errmsg); + php_error_docref(NULL TSRMLS_CC, E_WARNING, + "SQLite: failed to open/create session database `%s' - %s", save_path, errmsg); sqlite_freemem(errmsg); return FAILURE; } @@ -53,13 +54,15 @@ sqlite_busy_timeout(db, 60000); sqlite_exec(db, "PRAGMA default_synchronous = OFF", NULL, NULL, NULL); - + sqlite_exec(db, "PRAGMA count_changes = OFF", NULL, NULL, NULL); + /* This will fail if the table already exists, but that's not a big problem. I'm unclear as to how to check for a table's existence in SQLite -- that would be better here. */ sqlite_exec(db, "CREATE TABLE session_data (" - " sess_id TEXT PRIMARY KEY," - " value TEXT, updated INTEGER " + " sess_id PRIMARY KEY," + " value TEXT, " + " updated INTEGER " ")", NULL, NULL, NULL); PS_SET_MOD_DATA(db);