[Erp5-report] r28548 - in /erp5/trunk/bt5/erp5_dms: SkinTemplateItem/portal_skins/erp5_dms/...

[nobody at svn.erp5.org]

Author: ivan
Date: Fri Aug 21 14:53:23 2009
New Revision: 28548

URL: http://svn.erp5.org?rev=28548&view=rev
Log:
Optimize SQL query to use full text search (i.e. index) in order to find related documents (i.e. referencing documents) rather than like (which scan all table rows).

Modified:
    erp5/trunk/bt5/erp5_dms/SkinTemplateItem/portal_skins/erp5_dms/Base_zGetImplicitPredecessorValueList.xml
    erp5/trunk/bt5/erp5_dms/bt/change_log
    erp5/trunk/bt5/erp5_dms/bt/revision

Modified: erp5/trunk/bt5/erp5_dms/SkinTemplateItem/portal_skins/erp5_dms/Base_zGetImplicitPredecessorValueList.xml
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_dms/SkinTemplateItem/portal_skins/erp5_dms/Base_zGetImplicitPredecessorValueList.xml?rev=28548&r1=28547&r2=28548&view=diff
==============================================================================
--- erp5/trunk/bt5/erp5_dms/SkinTemplateItem/portal_skins/erp5_dms/Base_zGetImplicitPredecessorValueList.xml [utf8] (original)
+++ erp5/trunk/bt5/erp5_dms/SkinTemplateItem/portal_skins/erp5_dms/Base_zGetImplicitPredecessorValueList.xml [utf8] Fri Aug 21 14:53:23 2009
@@ -125,7 +125,7 @@
       AND <dtml-var "query[\'where_expression\']">\n
       </dtml-if>\n
       AND\n
-        <dtml-sqltest "\'%\'+str(reference)+\'%\'" column=SearchableText op=like type=string>\n
+        MATCH(SearchableText) AGAINST(<dtml-sqlvar reference type=string>)\n
       AND\n
         <dtml-sqltest reference op=ne type=string>\n
     ORDER BY reference, language_order DESC, version DESC, revision DESC\n
@@ -211,7 +211,7 @@
       AND <dtml-var "query[\'where_expression\']">\n
       </dtml-if>\n
       AND\n
-        <dtml-sqltest "\'%\'+str(reference)+\'%\'" column=SearchableText op=like type=string>\n
+        MATCH(SearchableText) AGAINST(<dtml-sqlvar reference type=string>)\n
       AND\n
         <dtml-sqltest reference op=ne type=string>\n
     ORDER BY reference, language_order DESC, version DESC, revision DESC\n

Modified: erp5/trunk/bt5/erp5_dms/bt/change_log
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_dms/bt/change_log?rev=28548&r1=28547&r2=28548&view=diff
==============================================================================
--- erp5/trunk/bt5/erp5_dms/bt/change_log [utf8] (original)
+++ erp5/trunk/bt5/erp5_dms/bt/change_log [utf8] Fri Aug 21 14:53:23 2009
@@ -1,3 +1,6 @@
+2009-08-21 ivan
+* Use full text search to find related documents (i.e. referencing documents)
+
 2009-08-12 Kazuhiko
 * use iframe_content in OOoDocument_viewAsWeb for Drawing and Presentation to have better paginations.
 * use OOoDocument_viewAsWeb instead of Drawing_viewAsWeb in all preview for Drawing and Presentation.

Modified: erp5/trunk/bt5/erp5_dms/bt/revision
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_dms/bt/revision?rev=28548&r1=28547&r2=28548&view=diff
==============================================================================
--- erp5/trunk/bt5/erp5_dms/bt/revision [utf8] (original)
+++ erp5/trunk/bt5/erp5_dms/bt/revision [utf8] Fri Aug 21 14:53:23 2009
@@ -1,1 +1,1 @@
-1008
+1009