On Sun, Mar 9, 2008 at 1:02 PM, Aerik <aerik(a)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.