[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