In Reply To:
There is an explanation in the manual about the different indexing schemes and the advantages and disadvantages of each one.[/quote] I just read it over and tried each scheme manually. I found that internal and mysql schemes do not return any matches for "Roy". It may be faster when searching for something like "David Blaine", but if users can't find something that is actually in the db, it is NOT what I need.
In Reply To:
I definitely wouldn't recommend using Nonindexed - you will find that the search is much slower as your database grows and I don't think the results will be as good.[/quote]
After reading the manual and tweaking things, I found this to be true. It will not display the relevant searches, and it is a lot slower than any other scheme.
In Reply To:
I'm not sure why the results aren't found using mysql indexing. I think you may still need to put weights on the fields that you want to be searchable. Try making sure that you have suitable weights and then changing back to mysql and see whether that fixes it.[/quote] I double checked it, and my weights were just the way they should be (title 3 etc).
The funny thing is, MSSQL seems to be my best bet. The results are quick, and it actually finds what I'm looking for. The funny thing is, I do not have MSSQL; I have MYSQL (my version is supported according to the manual). Why would this return results and be my best bet? It eludes me.
Anyway, thanks for the help. I solved my problem although I don't understand why the solution works. If you have any other ideas as to why, let me know.
- Jonathan
