Forum Moderators: open

Message Too Old, No Replies

Performance with both Index and FullText Enabled

         

HoboTraveler

5:45 am on Apr 10, 2007 (gmt 0)

10+ Year Member



Hi All,

On a MySQL database with ~500,000 records, is it ok to enable both the index and fulltext on two varchar(255) fields?

Basically, I will use LIKE 'foo%' so this will use index and fulltext for match against. I understand that LIKE 'foo%' does not work with fulltext so I need to enable Index for LIKE queries.

Does enabling both index and fulltext have a negative effect on queries?

TIA

justageek

11:51 pm on Apr 10, 2007 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Does enabling both index and fulltext have a negative effect on queries?

The short answer is no. It'll work just fine.

JAG