[Erp5-report] r38125 kazuhiko - in /erp5/trunk/bt5/erp5_full_text_sphinxse_catalog: Catalog...

[nobody at svn.erp5.org]

Author: kazuhiko
Date: Thu Sep  2 14:18:46 2010
New Revision: 38125

URL: http://svn.erp5.org?rev=38125&view=rev
Log:
2010-09-02 Kazuhiko
* XXX limit indexing full text size up to approx. 8MB, otherwise SphinxQL operations fail for very large texts.

Modified:
    erp5/trunk/bt5/erp5_full_text_sphinxse_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_catalog_sphinxse_index_list.xml
    erp5/trunk/bt5/erp5_full_text_sphinxse_catalog/bt/change_log
    erp5/trunk/bt5/erp5_full_text_sphinxse_catalog/bt/revision

Modified: erp5/trunk/bt5/erp5_full_text_sphinxse_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_catalog_sphinxse_index_list.xml
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_full_text_sphinxse_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_catalog_sphinxse_index_list.xml?rev=38125&r1=38124&r2=38125&view=diff
==============================================================================
--- erp5/trunk/bt5/erp5_full_text_sphinxse_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_catalog_sphinxse_index_list.xml [utf8] (original)
+++ erp5/trunk/bt5/erp5_full_text_sphinxse_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_catalog_sphinxse_index_list.xml [utf8] Thu Sep  2 14:18:46 2010
@@ -107,7 +107,7 @@ VALUES\n
 <dtml-in prefix="loop" expr="_.range(_.len(uid))">\n
 (\n
   <dtml-sqlvar expr="uid[loop_item]" type="int">,  \n
-  <dtml-sqlvar expr="SearchableText[loop_item] or \'\'" type="string">\n
+  <dtml-sqlvar expr="(SearchableText[loop_item] or \'\')[:8388550]" type="string">\n
 )\n
 <dtml-if sequence-end>\n
 <dtml-else>\n
@@ -163,7 +163,7 @@ VALUES\n
 <dtml-in prefix="loop" expr="_.range(_.len(uid))">\n
 (\n
   <dtml-sqlvar expr="uid[loop_item]" type="int">,  \n
-  <dtml-sqlvar expr="SearchableText[loop_item] or \'\'" type="string">\n
+  <dtml-sqlvar expr="(SearchableText[loop_item] or \'\')[:8388550]" type="string">\n
 )\n
 <dtml-if sequence-end>\n
 <dtml-else>\n

Modified: erp5/trunk/bt5/erp5_full_text_sphinxse_catalog/bt/change_log
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_full_text_sphinxse_catalog/bt/change_log?rev=38125&r1=38124&r2=38125&view=diff
==============================================================================
--- erp5/trunk/bt5/erp5_full_text_sphinxse_catalog/bt/change_log [utf8] (original)
+++ erp5/trunk/bt5/erp5_full_text_sphinxse_catalog/bt/change_log [utf8] Thu Sep  2 14:18:46 2010
@@ -1,2 +1,5 @@
+2010-09-02 Kazuhiko
+* XXX limit indexing full text size up to approx. 8MB, otherwise SphinxQL operations fail for very large texts.
+
 2010-08-19 Kazuhiko
 * initial commit
\ No newline at end of file

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=38125&r1=38124&r2=38125&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] Thu Sep  2 14:18:46 2010
@@ -1 +1 @@
-1
\ No newline at end of file
+2
\ No newline at end of file