You may try increasing your sort_buffer_size and key_buffer_size, see
if that speeds up the searching and sorting.
On May 25, 2004, at 9:54 AM, James Drabb wrote:
When I run a FULLTEXT search and view the process list of MySQL in
MySQL,
I see in the state column that MySQL is "sorting results" which appears
to
take up some time.
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]