From: Jerry Schwartz (jschwartzthe-infoshop.com)
Date: Thu Jun 12 2008 - 15:00:06 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

>-----Original Message-----
>From: Rory McKinley [mailto:rorymckinleylistsgmail.com]
>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 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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]