Hi
Is sphinxsearch avialable only on for windows
regards
anandkl
On 6/13/08, Rory McKinley [EMAIL PROTECTED] wrote:
mos wrote:
snip
Why not switch to Sphinx full text search for MySQL? It is faster and can
handle more data than MySQL's built in fulltext search.
-Original Message-
From: Ananda Kumar [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2008 10:48 AM
To: [EMAIL PROTECTED]
Cc: mos; mysql@lists.mysql.com
Subject: Re: Fulltext index -first query slow, subsequent queries fast
Hi
Is sphinxsearch avialable only on for windows
Hi List
I have a table with a fulltext index across five fields, with about 2.2
million records and a data size of about 5.6 GB (index another 3.5 GB).
When I test a query that uses fulltext matching, the first run takes
about 15-16 seconds to complete. The second run takes about 0.1 sec and
-Original Message-
From: Rory McKinley [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2008 3:20 PM
To: mysql
Subject: Fulltext index -first query slow, subsequent queries fast
Hi List
I have a table with a fulltext index across five fields, with about 2.2
million records and a data
Jerry Schwartz wrote:
File system, or disk caching, uses some kind of algorithm to hold chunks of
files in system RAM. That way a program can get to it more quickly than if
it had to go out to the disk. The algorithms vary, depending upon the smarts
of the program and the smarts of the file
From: Rory McKinley [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2008 4:57 PM
To: Jerry Schwartz; mysql
Subject: Re: Fulltext index -first query slow, subsequent queries fast
Jerry Schwartz wrote:
File system, or disk caching, uses some kind of algorithm to hold
chunks of
files in system
At 02:20 PM 6/12/2008, you wrote:
Hi List
I have a table with a fulltext index across five fields, with about 2.2
million records and a data size of about 5.6 GB (index another 3.5 GB).
When I test a query that uses fulltext matching, the first run takes about
15-16 seconds to complete. The
mos wrote:
snip
Why not switch to Sphinx full text search for MySQL? It is faster and
can handle more data than MySQL's built in fulltext search.
http://www.sphinxsearch.com/
Mike
snip
I have read about sphinx and the good performance boost it provides -
unfortunately there is a lot of