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 - 15:00:06 CDT
>From: Rory McKinley [mailto:rorymckinleylistsgmail.com]
>Sent: Thursday, June 12, 2008 3:20 PM
>Subject: Fulltext index -first query slow, subsequent queries fast
>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
>subsequent runs will all all ge around the 0.1 sec time.
>The query that I use has a call to NOW() as one of the criteria, so i
>know that the query results will not be cached. Yet, the times would
>suggest that some sort of caching effect is being observed.
[JS] It may well be the file system that is doing the caching.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql