Simetrical <Simetrical+wikilist@...> writes:
When I click "Submit Query" for the default query "+Living_People +Americans", I get a negative "Completed in" time the first one or two times I try it. Then it starts giving positive times for all the queries I try. I don't seem to be able to reproduce it.
<snip>
Of course. I was wondering what ideas you had in the direction of improving this backend with pagination. It's not actually something I had thought of before, but it's pretty important. And it will hurt MySQL, I suspect, since it always has to do a filesort when retrieving by fulltext index and sorting by anything other than relevance.
Okay, I was doing something stuipd with php's microtime - that's why the weird values. Fixed it now. As far as I can tell, Lucene doesn't really do pagination, you get the whole result set, then just display the pages you care about. I haven't messed with sort at all. Frankly, I think my next efforts will be to a) learn more about compiling and b) set this up as a daemon so the executable is already in memory... maybe go ahead and open the index too, I'm not sure. And if I get that far, I'll add some pagination while I'm at it.
If anybody is even vaguely interested, I'd love to share code, etc. I really think clucene as a daemon could be a cool thing in it's own right, and could also be be a nice enencumbered search solution for use on Wikipedia.
Aerik