We have image column in our database?

Santhosh Kumar Jayaraman

14y2.7k

Hi,

we have image column in our database and when we try to retreive image, it takes very long time. Is there any way to improve performance?

Any solutions apart from the below
1. Instead of saving data in DB, store it in file system.
2. using varbinary column instead of image column.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Santhosh Kumar Jayaraman14y ago
I already said i cant use file system since we already had large volumes of data in DB. What i asked is there any way to retrieve images faster.
And i have fixed this by using sql server paging to retrieve only few records to fill in datatable.
nuthan raghav14y ago
Hi Santosh

Just let me know clearly what you are asking ...........

I think it is not possible that without storing the image how can we retrieve that image from database...........

Regards,
Raghav.
Santhosh Kumar Jayaraman14y ago
No, that is what i already mentioned any solutions apart from file system. This is not new application, this is an existing application and its very hard to move such a big data.
nuthan raghav14y ago
Hi Santosh

Instead of storing the whole image in the database you can store the file path of that image in database and the image can be stored in the file ..........

I think below code will be useful for u..

if (fulLogo.HasFile)
{
string ImageName = System.IO.Path.GetFileName(fulLogo.PostedFile.FileName);
ImageName = ImageName.Replace(" ", "");
fulLogo.PostedFile.SaveAs(Server.MapPath("Resources/images/CategoryLogos/" + ImageName));

Logo = ImageName;
}