joomla/joomla-cms — Issue #121: Finder / Smart Search Index Hangs on Large Content Sites
Author: cspratt
Created: 2012-02-05 18:50:28+00:00
State: open

I have a #_content table of just about 3Gigs, 30k+ Articles and 4k+ Categories. In earlier versions of Finder before it was integrated into the latest release of Joomla 2.5 Stable I had the same problem I'm having now. It hangs and sometimes crashes my server requiring a Hard Reboot. I think this is due to having specific articles that are in pagebreak standards almost 400 book pages long. I have been building an online library using Joomla (which in retrospect may have been a bad idea, due to Joomla not really having the search functionality to deal with EXTREMELY large content based sites, and also that it uses MySQL which can be a huge bottleneck with large sites) and I have been letting the GUI Indexer run for about 9 hours now and it is hung up on 10% which was what happened earlier on in development when I tried this. I have used the CLI as well and let it run for 3 days and it never finished, and eventually shot up an error which ultimately nullified all the prior indexing.

I have submit this issue to the Joomla! Bug Squad on Google Groups, yet it seems to have never been approved by a Moderator :(

System Specs:
Rackspace Cloud Server
12 GIGS DDR3
PHP Built On	Linux 2.6.18-238.19.1.el5xen #1 SMP Fri Jul 15 08:16:59 EDT 2011 x86_64
Database Version	5.5.15
Database Collation	utf8_general_ci
PHP Version	5.3.8
Web Server	Apache/2.2.3 (CentOS)
WebServer to PHP Interface	cgi-fcgi
Joomla! Version	Joomla! 2.5.1 Stable [ Ember ] 2-Feb-2012 14:00 GMT
Joomla! Platform Version	Joomla Platform 11.4.0 Stable [ Brian Kernighan ] 03-Jan-2012 00:00 GMT