Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: Jerry Schwartz (jschwartzthe-infoshop.com)
Date: Thu Jun 12 2008 - 16:15:58 CDT
>From: Rory McKinley [mailto:rorymckinleylistsgmail.com]
>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
>> files in system RAM. That way a program can get to it more quickly
>> it had to go out to the disk. The algorithms vary, depending upon the
>> of the program and the smarts of the file system. The system might
>> most recently used stuff, the most frequently used stuff, even the
>> thinks you will need based upon the pattern of use.
>Thanks for the explanation.
>So, in short, I am most likely hitting a wall with the fulltext index,
>and I am just getting lucky cos of the disk caching, but I am not going
>to be able to get away from that initial slow load...rats.
[JS] I can't agree or disagree. I used to be a performance consultant, but
that was in another life and I don't know anything about MySQL's own caching
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql