o2on svn commit
o2on-****@lists*****
2008年 5月 21日 (水) 19:42:52 JST
Revision: 86
http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi?root=o2on&view=rev&rev=86
Author: k-uehara
Date: 2008-05-21 19:42:51 +0900 (Wed, 21 May 2008)
Log Message:
-----------
datnameのインデックスを作成
dat一覧画面でのパフォーマンスアップ
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-05-17 12:09:23 UTC (rev 85)
+++ branches/BRANCH_0043/o2on/src.o2on/O2DatDB.cpp 2008-05-21 10:42:51 UTC (rev 86)
@@ -207,9 +207,10 @@
");"
"drop index if exists idx_dat_domain;"
"drop index if exists idx_dat_bbsname;"
- "drop index if exists idx_dat_datname;"
+// "drop index if exists idx_dat_datname;"
"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;";
err = sqlite3_exec(db, sql, NULL, 0, 0);
if (err != SQLITE_OK)