I just added a fulltext index to a table, and MATCH queries on the table
are timing out. Can anyone offer any insight on this?
The table has 2000 rows of data in it, and phpMyAdmin reports it as
having a total size of 244,228 bytes.
Table Structure:
CREATE TABLE Customers (
ID mediumint(9) NOT NULL auto_increment,
FirstName varchar(255) NOT NULL default '',
LastName varchar(255) NOT NULL default '',
Street1 varchar(255) NOT NULL default '',
Street2 varchar(255) NOT NULL default '',
City varchar(255) NOT NULL default '',
State varchar(50) NOT NULL default 'Utah',
Zipcode varchar(15) NOT NULL default '',
Phone1 varchar(50) NOT NULL default '',
Phone2 varchar(50) NOT NULL default '',
Fax varchar(50) NOT NULL default '',
Email varchar(255) NOT NULL default '',
Type varchar(255) NOT NULL default 'Customer',
Memo varchar(255) NOT NULL default '',
PRIMARY KEY (ID),
FULLTEXT KEY Name (FirstName,LastName)
) TYPE=MyISAM;
Query:
SELECT * FROM Customers WHERE MATCH (FirstName,LastName) AGAINST
('walker')
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.310 / Virus Database: 171 - Release Date: 12/19/2001
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
