Changed Autosuggester

Change Autosuggester so that it respects static-filters,accesslevels,publish up/down dates and article states
This code is not yet production ready but runs fine for me on a site with Joomla 2.5.17 since 2 years
I agree with you Chris. The Joins are definitely expensive. That is why i had to set SQL_BIG_SELECTS before running this code. I can only tell from my experience with the site for which i use this code for nearly 2 years now. The response time is probably not under a second, but the autocompleter IMO is still a good thing. For my client the autosuggester was useless when it gave deprecated results for unpublished articles. But don't get me wrong. As i said, i agree with Chris that in the long term there should be a better way to do the computing intensive things during the indexing process and not while running the autosuggester.
Perhaps we could make it a configurable Option to use a more accurate but slower autosuggester.
If you like to see the performance online, you can check it out here http://www.kino-hdh.de
The indexer statistics in the backend tells me that there are
107,237  expressions from  443 Links with 28 attributes in 4 groups at this site. I would expect, that this is a medium sized index.
What statistics would you want to see. Perhaps i could provide some data at least for that site