[Typo3] optimising (optimizing) indexed search

[Nate Russell]

Dave Chewter wrote:
> Hi All
> 
> We recently launched a large(ish) typo3 site and everything is goind 
> swimmingly, however as more and more pages are getting indexed (about 
> 10,000 live at the moment) the indexed search plugin has started to take 
> longer to process searches. Our currently stats from the backend 
> Indexing extension are:
> 
> index_phash:     8336
> index_words:     53438
> index_rel:     786879
> index_grlist:     8336
> index_section:     8336
> index_fulltext:     8336
> 
> We're going to probably double in size in the next 6 months - and a lot 
> of the pages are text rich, so my question is what are the best ways of 
> optimising the indexed search to generate results quicker. Should I 
> start adding indexed to tables in mysql, or are there any advanced 
> options i can turn off using typoscript to speed up execution. The site 
> I'm talking about is www.intersites.co.uk you can check out the search 
> there (on the front page and also category and resource centre search 
> boxes searching bits of the page tree).
> 
> I imagine long term we're going to have to start looking for another 
> solution, but i'm really happy with indexed search and would like to use 
> it for as long as possible.
> 
> Any pointers would be much appreciated.
> 
> Kind Regards
> Dave

Hello Dave,

I have the same problem. Our database is getting huge and our server is 
taking a beating. When someone does a complicated search it often takes 
a few minutes to get a reault or it crashes the DB. We are also looking 
for another solution which, for starters, will include at least a faster 
server where we have root access. Our stats currently look like this:

index_phash:   		10857
index_words:   		112099
index_rel:   		2198462
index_grlist:   	10857
index_section:   	10857
index_fulltext:   	10857

What I don't understand is why our index_rel is so much bigger. Our 
MySQL database is around 450MB! I wonder if I has some something 
configured wrong that makes it so large or if there is a way to trim the 
fat and get rid of useless data in some of the tables.

I did install a PHP accelerator but it seemed to actually make the 
problem worse. Have you tried this?

I like your site by the way. Good design and TYPO3 implementation.

Nate