[Erp5-report] r15604 - /erp5/trunk/products/CMFActivity/skins/activity/

[nobody at svn.erp5.org]

Author: vincent
Date: Fri Aug 10 17:32:39 2007
New Revision: 15604

URL: http://svn.erp5.org?rev=15604&view=rev
Log:
Add LIMIT statements to queries grabbing messages from table. As the ZMySQLDA connector downloads all results before handing them to Shared.DC.ZRDB.DA which strips extra messages, MySQL just wastes its bandwith sending unused messages, and wasting memory on client side at the same time.

Modified:
    erp5/trunk/products/CMFActivity/skins/activity/SQLDict_readMessageList.zsql
    erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_readMessageList.zsql

Modified: erp5/trunk/products/CMFActivity/skins/activity/SQLDict_readMessageList.zsql
URL: http://svn.erp5.org/erp5/trunk/products/CMFActivity/skins/activity/SQLDict_readMessageList.zsql?rev=15604&r1=15603&r2=15604&view=diff
==============================================================================
--- erp5/trunk/products/CMFActivity/skins/activity/SQLDict_readMessageList.zsql (original)
+++ erp5/trunk/products/CMFActivity/skins/activity/SQLDict_readMessageList.zsql Fri Aug 10 17:32:39 2007
@@ -27,3 +27,4 @@
 <dtml-if to_date> AND date <= <dtml-sqlvar to_date type="datetime"> </dtml-if>
 ORDER BY
      priority, date, uid
+LIMIT 1000

Modified: erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_readMessageList.zsql
URL: http://svn.erp5.org/erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_readMessageList.zsql?rev=15604&r1=15603&r2=15604&view=diff
==============================================================================
--- erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_readMessageList.zsql (original)
+++ erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_readMessageList.zsql Fri Aug 10 17:32:39 2007
@@ -23,3 +23,4 @@
 <dtml-if to_date> AND date <= <dtml-sqlvar to_date type="datetime"> </dtml-if>
 ORDER BY
     priority, date, uid
+LIMIT 1000