evolution-data-server r9930 - trunk/camel

[sragavan svn gnome org]

Author: sragavan
Date: Tue Jan 13 09:18:08 2009
New Revision: 9930
URL: http://svn.gnome.org/viewvc/evolution-data-server?rev=9930&view=rev

Log:
2009-01-13  Srinivasa Ragavan  <sragavan novell com>

	* camel/camel-db.c: Speed up total-count info, by counting indexed
	read.




Modified:
   trunk/camel/ChangeLog
   trunk/camel/camel-db.c

Modified: trunk/camel/camel-db.c
==============================================================================
--- trunk/camel/camel-db.c	(original)
+++ trunk/camel/camel-db.c	Tue Jan 13 09:18:08 2009
@@ -452,7 +452,7 @@
 	if (!cdb)
 		return -1;
 	
-	query = sqlite3_mprintf ("SELECT COUNT (*) FROM %Q", table_name);
+	query = sqlite3_mprintf ("SELECT COUNT (*) FROM %Q where read=0 or read=1", table_name);
 
 	ret = camel_db_count_message_info (cdb, query, count, ex);
 	sqlite3_free (query);