devxlogo

Fetch Only Required Columns From a Database to Improve Performance

Why Trust Us

The call ‘select * from ‘ becomes costly when tables have a lot of fields. Because every data field would be required to be sent across the network (or processed) and buffered, reducing the number of data fields fetched directly enhances query and application performance. Therefore, you should fetch only required columns from your database and avoid queries like ‘select * from ‘. The queries that check for the existence of a record and use ‘select * from ‘ should be modified by putting * into single quotes. For example, it is better to fire a query like

      select '*' from  where  =

in place of

      select * from  where  =

to check for the existence of a record.

Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.

See also  How Seasoned Architects Evaluate New Tech
Disclosure

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

Show More