[Gforge-commits] gforge ChangeLog,1.343,1.344

[tom]

Update of /cvsroot/gforge/gforge
In directory db.perdue.net:/tmp/cvs-serv24097

Modified Files:
        ChangeLog 
Log Message:
SQL Optimization: replaced a 'select *' with a 'select count(*)'

Index: ChangeLog
===================================================================
RCS file: /cvsroot/gforge/gforge/ChangeLog,v
retrieving revision 1.343
retrieving revision 1.344
diff -u -d -r1.343 -r1.344
--- ChangeLog   8 Apr 2004 19:44:08 -0000       1.343
+++ ChangeLog   8 Apr 2004 20:03:29 -0000       1.344
@@ -1,8 +1,11 @@
-2004-04-06  Tom Copeland <address@hidden>
+2004-04-08  Tom Copeland <address@hidden>
        
        * www/forum/include/ForumHTML.class: SQL optimization - replaced a 
'select *'
        with explicit field selection.  This really didn't save that much, 
since only
        only field was unused, but every little bit helps.
+       * common/include/User.class: SQL Optimization - replace a 'select *' 
with
+       a 'select count(*)'.  This query ranked # 22 (executed 364 times) on an 
+       overnight SQL analysis run, so this optimization should help a fair bit.
 
 2004-04-08