retriving image takes too long

Last Reply on Mar 28, 2016 03:20 AM By dharmendr

Posted on Mar 28, 2016 03:06 AM

Hi, retrieving image from sql database, on pageload takes too long, sometimes 6-8 seconds long. That is too much time to retrieve a binary file and display it on image button. How can I retrieve image in just 2 seconds?

Posted on Mar 28, 2016 03:20 AM

It depends on the query execution time. First you need to check the query in the sql server. Also select only the required columns if you are selecting all the columns from database.

Refer the below article.

Display image in Image control based on DropDownList selection in ASP.Net