[SimBot-commits] CVS: simbot/plugins sqlite-logger.pl,1.44,1.45

[Pete P. <fou...@us...>]

Update of /cvsroot/simbot/simbot/plugins
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv14244/plugins

Modified Files:
	sqlite-logger.pl 
Log Message:
This has been sitting here needing checking in for a while...
Use prepare_cached instead of prepare in a few spots, should save some
SQL time. Maybe.


Index: sqlite-logger.pl
===================================================================
RCS file: /cvsroot/simbot/simbot/plugins/sqlite-logger.pl,v
retrieving revision 1.44
retrieving revision 1.45
diff -u -d -p -r1.44 -r1.45
--- sqlite-logger.pl	6 May 2005 21:10:27 -0000	1.44
+++ sqlite-logger.pl	19 Jul 2005 02:26:39 -0000	1.45
@@ -23,7 +23,7 @@
 #   Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
 #
 # TODO:
-#   * see comment at about line 452
+#   * see comment at about line 600
 #
 
 
@@ -376,7 +376,7 @@ sub do_recap {
     
     my $nick_id = &get_nickchan_id($nick);
     
-    my $start_query = $dbh->prepare(
+    my $start_query = $dbh->prepare_cached(
         'SELECT id FROM chatlog'
         . ' WHERE channel_id = ?'
         . ' AND source_nick_id = ?'
@@ -387,7 +387,7 @@ sub do_recap {
         . ' LIMIT 1'
     );
     
-    my $end_query = $dbh->prepare(
+    my $end_query = $dbh->prepare_cached(
         'SELECT id FROM chatlog'
         . ' WHERE channel_id = ?'
         . ' AND source_nick_id = ?'
@@ -396,7 +396,7 @@ sub do_recap {
         . ' LIMIT 1'
     );
     
-    my $log_query = $dbh->prepare(
+    my $log_query = $dbh->prepare_cached(
         'SELECT time, source_nick_id, event,'
         . ' target_nick_id, content'
         . ' FROM chatlog'
@@ -490,7 +490,7 @@ sub access_log {
             # no nick specified, so how 'bout some generic stats?
             my $tmp_query;
             
-            $tmp_query = $dbh->prepare(
+            $tmp_query = $dbh->prepare_cached(
                 'SELECT time FROM chatlog'
                 . ' WHERE channel_id = ?'
                 . ' ORDER BY time'
@@ -499,7 +499,7 @@ sub access_log {
             my $start_date = localtime(($tmp_query->fetchrow_array())[0]);
             $tmp_query->finish;
             
-            $tmp_query = $dbh->prepare(
+            $tmp_query = $dbh->prepare_cached(
                 'SELECT count() FROM chatlog'
                 . ' WHERE channel_id = ?'
             );