Hi,
Regarding the "Simple Any word..." search, I think I found out what's wrong.
I have 6 lists. The default is "All Members" and then there are 5 smaller lists. I had "All Members" set to "Simple Exact Match" and I was testing the "Staff" list for "Simple Any word" and it wasn't working. I then changed the "All Members" list to "Simple Any word" and then the "Staff" search worked as expected. So it seems like all the other list searches are inheriting the Search attribute from the default list?
This may also be related to the issue #2 I mentioned earlier. If you pick one of the non-default lists and search it, then perform a second search, the second search works on the default list, not your list you were searching earlier.
I did try this on this site, and noticed I couldn't reproduce it here. So I'm wondering what could be different on my site that that is causing the problem... too bad it's on an intranet, otherwise I'd post a link.
Regarding the high resource usage as a reason for not implementing a single-box search, I guess that could be a good reason, although I can't seem to imagine a single MySQL statement causing such high resource usage. If it was a loop that checks one field at a time, maybe... but I imagine it'd be just one statement searching for one value in all fields.
Post edited by: riko, at: 2009/01/28 03:10