www

commit 4eb2fae0b3defcc8aa14609440ff0ba033558ac4
parent fbbfe93ce5c6a829921d2d9bb9d012fe5c5e6bce
Author: Dan Stillman <dstillman@zotero.org>
Date:   Sun, 18 Nov 2012 23:36:22 -0500

Potential optimization for itemTags lookup

Diffstat:
M
chrome/content/zotero/xpcom/sync.js
 | 
2
+-

1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/chrome/content/zotero/xpcom/sync.js b/chrome/content/zotero/xpcom/sync.js
@@ -2633,7 +2633,7 @@ Zotero.Sync.Server.Data = new function() {
 						var sql = "SELECT tagID FROM tags WHERE libraryID=? AND key=?";
 						var tagID = Zotero.DB.valueQuery(sql, [libraryID, key]);
 						
-						var sql = "SELECT COUNT(*) FROM itemTags WHERE tagID=?";
+						var sql = "SELECT COUNT(*) > 0 FROM itemTags WHERE tagID=?";
 						if (Zotero.DB.valueQuery(sql, [tagID])) {
 							var sql = "UPDATE tags SET clientDateModified=CURRENT_TIMESTAMP "
 								+ "WHERE tagID=?";