very nicely done. I too was having problems with searching, especially since I don't archive my topics/replies. I ended up relying on the integrated Google Search API that was made available which actually worked out really well too.
Thanks to all that have been involved in this mod.
Update... so I had a chance to use this all day and what a huge difference. I am going to have to implement this with my other projects at work. This is definitely a change in the way I do things from now on. Any more helpful indexing tips?
well, actually the mod works with all databases from what I can tell, but if you are using Access it just uses the existing search code.
I am going to install the code here later today so everyone can see the improvement.
The code has been running here for about a week, I have not implemented "full text" but you can still see a massive improvement in the search times. (for those that bother to use it )
Huw, I was wondering what was different with the search here. It is faster, but it doesn't return results that it should be returning. Any idea why?
Uploaded version G. search.asp and search_mssqlft.asp has changed.
New options on the search.asp page to allow the choosing of exact word matches "test" or loose matches "test", "testing", "tests" and whatnot. That would explain some of the missing returns. The old version defaulted to exact match.
One feature of SQL's FT searching is that it will only search for exact, inflectional or predicate matches. Being that it will find "test", "tests", "tested", etc but not "protest" if searching for "test". That would explain the other missing returns.
If someone has done the MySQL FT changes, could you share them so I can make this package complete? Otherwise, I'll try to start on it sometime in the near future.
Topic Locked
Posted - 13 September 2004 : 12:15:17
