> -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 sphi
Hi
Is sphinxsearch avialable only on for windows
regards
anandkl
On 6/13/08, Rory McKinley <[EMAIL PROTECTED]> wrote:
>
> mos wrote:
>
>
>> 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.sphinxsea
mos wrote:
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
I have read about sphinx and the good performance boost it provides -
unfortunately there is a lot of legacy code
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 s
>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
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 syste
>-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
