On Aug 22, 2007, at 1:35 PM, Ben Sgro ((ProjectSkyLine)) wrote:
I'll try to rebuild the index. In order to do so, do I just run the
command that I did to build the
original index, or is there a special syntax/command to do so?
Actually... I think this is the command:
REPAIR TABLE tbl_name QUIC
is confidential information intended only for the use
of the individual to whom it is addressed.
- Original Message -
From: Jon Baer
To: NYPHP Talk
Sent: Wednesday, August 22, 2007 12:18 PM
Subject: Re: [nyphp-talk] Tuning MySQL Full Text Search
I would say build an index if its items which wil
al to whom it is addressed.
- Original Message -
From: "Rob Marscher" <[EMAIL PROTECTED]>
To: "NYPHP Talk"
Sent: Wednesday, August 22, 2007 1:12 PM
Subject: Re: [nyphp-talk] Tuning MySQL Full Text Search
On Aug 22, 2007, at 12:42 PM, Ben Sgro ((ProjectSkyLine)) wrote:
On Aug 22, 2007, at 12:42 PM, Ben Sgro ((ProjectSkyLine)) wrote:
Hello Rob,
I'm happy w/the relevance, but the order isn't right
What do you mean by that? I thought you were sorting by relevance?
too many results are being returned (which is my own issue to fix).
Can you just apply a limit
is confidential information intended only for the use of the
individual to whom it is addressed.
- Original Message -
From: "Rob Marscher" <[EMAIL PROTECTED]>
To: "NYPHP Talk"
Sent: Wednesday, August 22, 2007 12:31 PM
Subject: Re: [nyphp-talk] Tuning MySQL Fu
om
Our products: www.project-contact.com
This e-mail is confidential information intended only for the use of the
individual to whom it is addressed.
- Original Message -
From: Jon Baer
To: NYPHP Talk
Sent: Wednesday, August 22, 2007 12:18 PM
Subject: Re: [nyphp-talk] Tuning
On Aug 22, 2007, at 10:50 AM, Ben Sgro ((ProjectSkyLine)) wrote:
I'd like to tune this to have different weights for words, because
I'm not happy with the search results.
$dbObject->DatabaseQuery('SELECT id, title, body, links_to,'
. ' MATCH(title, body)'
I would say build an index if its items which will rarely change.
There is real power in using a Lucene-based index for full text
search that a DB does not really focus on and would meet your
requirements better. Ive recently put a 200k record set thorough
Zend_Search and the clients were
Hello All,
I've got search for very small database working fine. However, I'd like to tune
this to have
different weights for words, because I'm not happy with the search results.
Are there any good books or whitepapers on tuning mysql for fulltext search?
Here's the query:
$dbObject
