SQL Server Performance Forum – Threads Archive

Loading Images Faster

Dear All,
We are using VB.Net and SQL SERVER, All Images are stored in Binary. But loading them on a page is taking time. How do I load them faster? Kindly suggest me.
Thanks Usha Rani

How about storing the File path than storing image itself?
All you need is to use FileSystem object to retreive image from the directory Madhivanan Failing to plan is Planning to fail

Will this give adequate performance? Won’t storing in DB gives better performance? Just clearing my thought. Do let me know. Thanks Usha Rani

I think It is better to store the file path than using image column
You need to use GetChunk and AppChunk methods to store and Retreive image if you stored image itself
Madhivanan Failing to plan is Planning to fail

We follow the methodology presented in this link. But it is slow. http://www.dotnetbips.com/29E37690-7C6D-474E-836C-9F72BC53C27A.aspx?articleid=101 How do we use the methods GetChunk and AppChunk methods and if we use these will we have good benefit? Thanks Usha Rani

Using GetChunk method with VB is suggestable, but on the basis of databsae management it is better to store the filepath and use the file server to store images on operating system. This has been discussed many times in the forum and if you’re comfortable with your current approach, then continue. Image data can get a bit messy if you run into problems on the server. If you had to have a torn page, you will lose a considerable amount of data. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

If you have time read this
http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx
completely. It’s a very good discussion on BLOBs in general. If not, just scroll down to the bottom. There you’ll find some code snippets.
Also
http://support.microsoft.com/default.aspx?scid=kb;EN-US;194975
http://support.microsoft.com/default.aspx?scid=kb;EN-US;309158 —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

I have not been in touch for a long time. Thanks to all of you. Thae links have provided me with good insight. Thanks once again.
Usha Rani Usha Rani

]]>