Mailing-List: contact java-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: java-user@lucene.apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Mime-Version: 1.0 (Apple Message framework v749.3)
In-Reply-To: <443FFB4A.3070806@curtin.com>
References: <FD3C153E-0DF4-4F0B-9F84-9588E0942529@mac.com>
 <A91E7AC7-BAF6-4E02-86FC-29AB488E274A@ehatchersolutions.com>
 <EA520C39-0CF4-489C-8B2F-E4C7BC9E598D@mac.com>
 <96DBA66E-4ED6-40A3-A779-4086BDE8005C@ehatchersolutions.com>
 <DD7662C3-20A8-4380-87C8-17AD5385BEB0@mac.com>
 <2911FD5311EEF04EABA7B8DAC518C1F60B9B11F4@uwamail.unitedway.org>
 <5DF5DE32-C290-4679-A52F-D5032F59741B@mac.com> <443FFB4A.3070806@curtin.com>
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
Message-Id: <3C12E3AD-70A3-451F-BFA6-061B4EC4102C@mac.com>
Content-Transfer-Encoding: 7bit
From: Jeremy Hanna <jeremy_hanna@mac.com>
Subject: Re: Boosting Fields (in index) or Queries
Date: Fri, 14 Apr 2006 14:48:37 -0600
To: java-user@lucene.apache.org

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: java-user-unsubscribe@lucene.apache.org
> For additional commands, e-mail: java-user-help@lucene.apache.org
>


---------------------------------------------------------------------
To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
For additional commands, e-mail: java-user-help@lucene.apache.org