evolution-data-server r9929 - branches/gnome-2-24/camel

[sragavan svn gnome org]

Author: sragavan
Date: Tue Jan 13 09:15:20 2009
New Revision: 9929
URL: http://svn.gnome.org/viewvc/evolution-data-server?rev=9929&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:
   branches/gnome-2-24/camel/ChangeLog
   branches/gnome-2-24/camel/camel-db.c

Modified: branches/gnome-2-24/camel/camel-db.c
==============================================================================
--- branches/gnome-2-24/camel/camel-db.c	(original)
+++ branches/gnome-2-24/camel/camel-db.c	Tue Jan 13 09:15:20 2009
@@ -449,7 +449,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);