|
|
 |
SQL SELECT *It's a good idea as well as better coding practice to avoid using SELECT * in your SQL statements as it is inefficient. Listing all the fields expressly will improve the retrieval speed. Why pull all the fields and their data when perhaps you only need 2 or 3 fields. By only selecting the fields we need you reduce the amount of data pulled from the database and thus speed up our web application. I find sometimes that if I don't name the fields that when I come to write out the recordset that I have to check and check against the database to make sure that I have the correct fields and spelt them properly. Just one thing, I realise that on some of the tutorials on this site i use SELECT *, shame on me though I must rewrite them once I get the time.
Site developed by Michael Wall - Web Design Belfast N.Ireland. |
|
