fast select

[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?

 

[hos2]

perhaps put an index on the field

 

[jimbojames5645]

There is already an index on that field.

 

[hos2]

perhaps leave out the count option. if there are records in the recordset you can see that by the number of rows returned


$query="SELECT field from tablename where field ='$data";
$rs=mysql_query($query,$conn);
$list = mysql_num_rows($rs);