[Erp5-report] r38195 kazuhiko - in /erp5/trunk/bt5/erp5_full_text_sphinxse_catalog: SkinTem...

nobody at svn.erp5.org nobody at svn.erp5.org
Wed Sep 8 14:46:50 CEST 2010


Author: kazuhiko
Date: Wed Sep  8 14:46:49 2010
New Revision: 38195

URL: http://svn.erp5.org?rev=38195&view=rev
Log:
make ERP5Site_reindexSphinxSE script much faster by not accessing ZODB.

Modified:
    erp5/trunk/bt5/erp5_full_text_sphinxse_catalog/SkinTemplateItem/portal_skins/erp5_sphinxse/ERP5Site_reindexSphinxSE.xml
    erp5/trunk/bt5/erp5_full_text_sphinxse_catalog/bt/revision

Modified: erp5/trunk/bt5/erp5_full_text_sphinxse_catalog/SkinTemplateItem/portal_skins/erp5_sphinxse/ERP5Site_reindexSphinxSE.xml
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_full_text_sphinxse_catalog/SkinTemplateItem/portal_skins/erp5_sphinxse/ERP5Site_reindexSphinxSE.xml?rev=38195&r1=38194&r2=38195&view=diff
==============================================================================
--- erp5/trunk/bt5/erp5_full_text_sphinxse_catalog/SkinTemplateItem/portal_skins/erp5_sphinxse/ERP5Site_reindexSphinxSE.xml [utf8] (original)
+++ erp5/trunk/bt5/erp5_full_text_sphinxse_catalog/SkinTemplateItem/portal_skins/erp5_sphinxse/ERP5Site_reindexSphinxSE.xml [utf8] Wed Sep  8 14:46:49 2010
@@ -53,14 +53,14 @@
             <value> <string>portal_catalog = context.portal_catalog\n
 sql_catalog = portal_catalog.getSQLCatalog(sql_catalog_id)\n
 \n
-LIMIT = 10\n
+LIMIT = 100\n
 \n
 i = 0\n
 while True:\n
   full_text_list = portal_catalog(select_list=(\'full_text.SearchableText\',), limit=(i*LIMIT, LIMIT))\n
   if len(full_text_list) == 0:\n
     break\n
-  object_list = [dict(uid=x.getUid(), SearchableText=x.getSearchableText()) for x in full_text_list]\n
+  object_list = [dict(uid=x.uid, SearchableText=x.SearchableText) for x in full_text_list]\n
   parameter_dict = {}\n
   for x in object_list:\n
     for property in (\'uid\', \'SearchableText\'):\n

Modified: erp5/trunk/bt5/erp5_full_text_sphinxse_catalog/bt/revision
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_full_text_sphinxse_catalog/bt/revision?rev=38195&r1=38194&r2=38195&view=diff
==============================================================================
--- erp5/trunk/bt5/erp5_full_text_sphinxse_catalog/bt/revision [utf8] (original)
+++ erp5/trunk/bt5/erp5_full_text_sphinxse_catalog/bt/revision [utf8] Wed Sep  8 14:46:49 2010
@@ -1 +1 @@
-3
\ No newline at end of file
+4
\ No newline at end of file




More information about the Erp5-report mailing list