Fast select

[Azu]

Can someone please tell me if there is a faster way then

if(mysql_result(timed_query("select count(*) from table where info='blah'",$DB),0))

to just see if a row exists that matches the where? I don't actually want to retrieve any data from it, just see if it exists..

[Azu]

Please is there a faster way? X_x

[btherl]

I hope timed_query() does error checking.

 

If you're finding that query is slow, you probably need an index on info.

[Azu]

Timed_query is just a mysql_query except it adds time to a variable so I can see how long it took to run ^^

And what exactly is the best way to do an index?

[fenway]

Post the EXPLAIN output... and SHOW CREATE TABLE

[gluck]

Can someone please tell me if there is a faster way then

if(mysql_result(timed_query("select count(*) from table where info='blah'",$DB),0))

to just see if a row exists that matches the where? I don't actually want to retrieve any data from it, just see if it exists..

 

You will have to retrieve data from the DB server. How would the scripting language know if the record exists or not. You could simply return a 1 or 0 instead of columns but yes you would have to return data.

 

[Azu]

I mean is there a way to just ask the DB if the record exists or not, and the DB will just see if it exists and tell PHP if it exists, without actually reading the data in it (except for searching)?

[dough boy]

query:

 

SELECT id
FROM table
WHERE id = $id
LIMIT 0,1

 

php:

 

if(mysql_num_rows($result) > 0)
  do something.

 

As stated above you have to return "something".  Just make sure that something is as small as possible.  Also make sure you have indexed your 'id' field.

[gluck]

query:

 

SELECT id
FROM table
WHERE id = $id
LIMIT 0,1

 

php:

 

if(mysql_num_rows($result) > 0)
  do something.

 

As stated above you have to return "something".  Just make sure that something is as small as possible.  Also make sure you have indexed your 'id' field.

 

You could choose this technique too.

Again you will have to execute the query and the result will be returned to the scripting language.