[Checkins] SVN: relstorage/branches/1.1/relstorage/adapters/common.py Optimized a query

Shane Hathaway shane at hathawaymix.org
Wed Jul 23 14:06:38 EDT 2008


Log message for revision 88770:
  Optimized a query

Changed:
  U   relstorage/branches/1.1/relstorage/adapters/common.py

-=-
Modified: relstorage/branches/1.1/relstorage/adapters/common.py
===================================================================
--- relstorage/branches/1.1/relstorage/adapters/common.py	2008-07-23 17:52:21 UTC (rev 88769)
+++ relstorage/branches/1.1/relstorage/adapters/common.py	2008-07-23 18:06:37 UTC (rev 88770)
@@ -922,8 +922,8 @@
 
         # Get the list of changed OIDs and return it.
         stmt = """
-        SELECT DISTINCT zoid
-        FROM object_state
+        SELECT zoid
+        FROM current_object
         WHERE tid > %(tid)s
         """
         if ignore_tid is None:



More information about the Checkins mailing list