[SOLVED] query question

[jakebur01]

i have a table with a lot of extra columns that I don't use. If i delete those extra columns will it allow php to run faster?

[dbo]

Nope, it's more of a database issue. But if you're sucking back a bunch of fields you don't need and iterating over them that could potentially slow things down. I suggest always writing your queries to only select out the fields you need. Avoid using SELECT *.

[Fadion]

If ure using everywhere in your script "SELECT column1, column2 FROM table" then ure ok, but if ure selecting * i think ull have faster queries. Also when u dont need smth, why keep it.

[rameshfaj]

It depends on your query.If there are unnecessary information that u are selecting from the tables,then it is better to select only required one.This itself filters the data from the database.

If u are selecting all the entries from the table better do only required selection, this will make the query optimal and less overhead,so the connection returns faster and the script can proceed further,so seems some faster.