Page is a not externally linkable
- Code, Content, and Presentation
-- Databases
---- Is SELECT * FROM .slow?


Demaestro - 4:56 pm on Aug 27, 2010 (gmt 0)


Some other things to consider.

It isn't just the DB that you will affect by returning all fields.

calls to things like mysql_fetch_array will be more costly on the processor as well it also affects the DB_Conn in many cases.

1script is right you do have to make sure that you know which fields you need and it isn't just the ones you are displaying on page.


Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4193106.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com