Web developers often have a plethora of languages at their disposal. It is crucial for developers to use the proper language for the job.
Let’s review the following code. In the first example, the developer is selecting all columns and all rows from the customer table. In the second example, the developer is selecting only the first name, last name and address from the customer table for a single customer with ID 1001. Not only does the second query limit the columns that are returned, it will also perform better.
When you are writing code, make sure that it works efficiently.
Too many developers are satisfied with code that performs adequately on 100 rows of data, with little thought ahead to when the database will have 10,000 rows.