Need faster way to check to see if records are in table

[jimbojames5645]

In order to determine if a record is in a table, i am using select count(1) from tablename where field = 'data'

I have run this query for millions of records against a table that is has 10s of millions in it. Is there a faster way to check to see if a record exists, maybe checking multiple records at once?

 

[sleipnir214]

When you perform count(*), MySQL doesn't actually do a count of the records that match the criterion. It examines the table descriptors to calculate the value. Just make sure that all the fields used in your criteria are indexed.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!