MySQL Forums
Forum List  »  Performance

Query performance
Posted by: miloscup
Date: November 07, 2005 03:53AM

I need write down all `name` from MySQL database, table2.

If I use Query2 respons from database will be faster as with Query1????

Normaly I use this kind of query (query2) but I have problem with long respons from MySQL. Can it helps me if I rewrite all queries to typ1 - I will only require what I need not all as in query2?

Table2 obtain these colums - `name`, `pass`, `email`, `id`, `other`, `other`

$query1 = "SELECT `name`
FROM $table2
";

$query2 = "SELECT *
FROM $table2
";

Options: ReplyQuote


Subject
Views
Written By
Posted
Query performance
2103
November 07, 2005 03:53AM
1409
November 07, 2005 04:20AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.