Databases

ASP.NET Web Forms Databases Web Development

Using SqlDataReader NextResult to improve performance

by John Avis | July 31, 2014
On database-driven websites it is commonplace to execute multiple database queries to generate just one page. For example, on the home page of an ecommerce website you might get a list of categories, a list of banner advertisements to display, a list of featured products, and a list of top selling products. I investigate whether it was more efficient to put these multiple queries into one stored procedure and use the SqlDataReader's Next Result method to get the data all in one go.



Tags

About me

...random postings about web development and programming, Internet, computers, electronics and automotive topics.

I recommend ASPnix for web hosting and Crazy Domains for domain registration.

Subscribe

Get the latest posts delivered to your inbox.