I still have a similar problem with the boost factor. I change the
name to have the AND operator and set that query's boost to a very
high value in relation to the others. I also have a regular OR based
name so that it doesn't rule those out. However whenever I change
the boost values with the queries, nothing, absolutely nothing
changes with the results. Besides that - I search for: playstation
game. The only value that has both playstation and game in the name
field is Hit number 20. That's really why I put the name AND
operator in there with such a high boost value, to see if it would
bring that single ANDed record towards the top, but nothing. Am I
doing something wrong in all of this? Am I doing the boost wrong or
something?
On Apr 14, 2006, at 1:43 PM, Michael D. Curtin wrote:
Jeremy Hanna wrote:
I would use a database function to force the ordering like the
one your provided that works in Oracle, but it doesn't look like
mysql 5 supports that. If anyone else knows of a way to force
the ordering using mysql 5 queries, please respond. I think I'll
just resort them when they get back though.
If there's nothing in the relational table that specifies the
ordering, I'm afraid you've probably got similar problems in other
places. RDBMSes don't guarantee to return rows in the order they
were INSERTed. Sure, early in the life of a table that will tend
to happen, but as DELETEs, then UPDATEs and new INSERTs get
processed, the on-disk order tends to get pretty jumbled. Note
that I'm talking about anything that uses the results of your
SELECT, not just your Lucene-related code.
If ordering of the rows is something your app needs, I recommend
adding a column that is expressly for ordering. A one-up integer
or something like that. I don't remember what the keyword in MySQL
is for that, but I'm pretty sure there is one. Then you can code
all your SELECTs with an ORDER BY clause that does what you want.
Good luck!
--MDC
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
