o2on svn commit
o2on-****@lists*****
2008年 7月 26日 (土) 17:17:23 JST
Revision: 107
http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi?root=o2on&view=rev&rev=107
Author: k-uehara
Date: 2008-07-26 17:17:23 +0900 (Sat, 26 Jul 2008)
Log Message:
-----------
DBチューニング
起動時analyzeをやめた
適宜begin; end;でトランザクションを利用
Modified Paths:
--------------
branches/BRANCH_0043/o2on/src.o2on/O2DatDB.cpp
Modified: branches/BRANCH_0043/o2on/src.o2on/O2DatDB.cpp
===================================================================
--- branches/BRANCH_0043/o2on/src.o2on/O2DatDB.cpp 2008-07-26 08:07:18 UTC (rev 106)
+++ branches/BRANCH_0043/o2on/src.o2on/O2DatDB.cpp 2008-07-26 08:17:23 UTC (rev 107)
@@ -249,7 +249,7 @@
"create index if not exists idx_dat_domain_bbsname_datname on dat (domain, bbsname, datname);"
"create index if not exists idx_dat_lastpublish on dat (lastpublish);"
"create index if not exists idx_dat_datname on dat (datname);";
- "analyze;";
+// "analyze;";
err = sqlite3_exec(db, sql, NULL, 0, 0);
if (err != SQLITE_OK)
goto error;
@@ -324,7 +324,7 @@
if (err != SQLITE_OK)
goto error;
- char sql[] = "analyze; vacuum dat;";
+ char sql[] = "begin;analyze;end; vacuum dat;";
err = sqlite3_exec(db, sql, NULL, 0, 0);
if (err != SQLITE_OK)
@@ -814,7 +814,10 @@
sqlite3_busy_timeout(db, 5000);
- wchar_t *sql = L"select count(*) from dat;";
+ wchar_t *sql =
+ L"begin;"
+ L"select count(*) from dat;"
+ L"end;";
err = sqlite3_prepare16_v2(db, sql, wcslen(sql)*2, &stmt, NULL);
if (err != SQLITE_OK)
@@ -915,7 +918,10 @@
goto error;
sqlite3_busy_timeout(db, 5000);
- wchar_t *sql = L"select sum(disksize) from dat;";
+ wchar_t *sql =
+ L"begin;"
+ L"select sum(disksize) from dat;"
+ L"end;";
err = sqlite3_prepare16_v2(db, sql, wcslen(sql)*2, &stmt, NULL);
if (err != SQLITE_OK)