Hello there, i have one table on my db who have 350k rows, how i see is start to get evrytime more slow, right now my website is open in 20 secounds ...

the command what im using is

PHP Code:

 $tag                = $_GET['tag'];

 $query              = mysql_query("SELECT * FROM tags WHERE TID = $tag");
 $result             = mysql_fetch_array($query) or die (mysql_error());
 $tagTitle           = $result['Tag']; 


Hope someone can tell me another way to be more good ... thank you !

Is there an index on TID?

Do you need every column? If not don't use SELECT *.

By the way you're wide open for a sql injection here. Validate and sanitize $tag.