On Sun, Mar 9, 2008 at 1:02 PM, Aerik aerik@thesylvans.com wrote:
What query did you run that got "Completed in -0.799299 seconds"? So far, I don't have any results like that...
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.
Yes, the second number is the lucene "score" which I agree probably isn't relevant for our purposes. Let me quickly state that I did not publish this as any kind of final product, but merely a demonstration of the speed of one possible approach, using real data. I can see already we'd need to tweak the query parser for our purposes too.
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.