For example, I have a database like this:
id | fname | lname | sex | age | tel | cell | address
If I do select cell, fname, address, sex
instead of doing select fname, sex, cell, address
, will that affect the speed of query, in big tables?
I did a quick check in phpmyadmin and it appeared to be taking same time, but I wanted to double check.
Thanks.
That won't make any difference.
However, omitting columns from the SELECT
clause will make it run faster since it'll send less data over the network.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With