Hi

We are looking to optimize the forums search facility, we have already put a top 50 on the proc that is called in the backend, but we have a feeling the forums might need Full Text indexing in SQL. If I understand it correctly the @filter parameter is made on run time and im having trouble finding where (can anyone point me in the right direction). The top 50 has made it quicker for words which show up often in the posts but if the searched word is quite rare the whole of forums posts are to be scanned before it give 2 results back and at time it takes about 25 sec to show something and we'r not keen on increasing the timeouts for 25 secs. Hope im making sense here

Secondly is there any other way ppl have optimized or quickened the search some how. We are using Forums 3.2 and DNN 4.4

Thanks

Thanks for the feedback, well we would like to go down the full text indexing route. Has anyone implemented it before? are there any blockades up ahead?

Im also having trouble tracing where the @filter parameter is made in the code which on runtime contains something like Post.Body LIKE '%baby%'. This might have to change if full text indexing is used. Any clues.

Thanks

I have changed search drastically for 4.4.01 of the module which is going through the release process. Performance against DNN data has not shown any problems since my changes. I will say that something like google search integration is far better than this module can do out of the box for several reasons, one of which is the full text indexing I cannot add to the module. Full text indexing on the posts body column allows the stored procedure to be change and does increase performance but as Mitchell said I cannot do this out of the box because not every host wants to allow this. My hope is that the DNN ISearchable interface is enhanced (being discussed) to handle overall searching much better.