>-----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 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 To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]