I'm strongly considering adding SQL Search to my site, but I've got a couple questions/concerns about it before I do...
Is it possible to sort results by date? Specificly, I'm looking at using this for a Drupal-based forum, and I'd like the default sorting to be newest post to oldest, by time of last post in the thread. That's the way most forums handle it, but as far as I can tell, there's no way to do that right now.
Also for forums & comments, it would be nice if the teaser showed the post where the result is from, rather than the first post in the thread.
If a search result is on page 2 of the thread, would it be possible to make the link go directly to page 2, or better yet directly to that post via an anchor?
Any word on having a textbox instead of a dropdown menu for search by username? (moshe weitzman mentioned this a while back at http://drupal.org/node/11753 but it doesn't look like it's been implemented yet)
What exactly is the difference between the three search modes? (like, full text, regexp) Is one faster/yield better results/etc?
Is there any difference in speed (plus or minus) versus the regular search.module?
Does it keep any sort of a cache of search results? For instance, is the entire query re-run every time, like when you go from one page of the search results to the next?
Is there any sort of search flood control? (ie so that people aren't bogging down the system with complex queries every 3 seconds)
Comments
Comment #1
nedjoIt's taken me a bit to get to this as there were so many questions!
Is it possible to sort results by date?
No.
No.
No.
All of these questions fall into the category "please go ahead and open a feature request issue--better yet, open an issue and post a patch".
I'll look at putting in place an interim fix until we implement autofill.
Speed differences will be obvious only on very large sites. There's an existing issue to add help text--I'll get to this when I get a chance.
Haven't done any benchmarking.
Comment #2
mindless commented