SQL and IIS hangs when large data is retrieved from BLOBS

[akshetrapal]

I am building a website with IIS Server4.0 and Sql Server 7.0.
From an asp page i call a VB Component. The component has a Stored Procedure to get the data from SQL 7.0 using recordset. The data is retrieved from a field which is used to store Images and Doc (data type=image, some thing to do with BLOB)These are the doc and images uploaded by users which are stored in database. Since the data being retrieved is very large(5 MB atleat) the stored procedure hangs the sql server and VB Component keeps waiting for the stored procedure to return the recordset. This causes the IIS Server to hang.
Is there a way that i can kill this stored procedure from the VB Component, if it does not return the result after a specific time and then throw a message to the ASP page?
Please help as this is urgent.

 

[smbure]

These may be of some help to you:

http://www.microsoft.com/mind/defau...htm&nav=/mind/0798/inthisissuecolumns0798.htm

http://support.microsoft.com/support/kb/articles/Q173/3/08.ASP

One note - most companies opt to store the image files on the server, and just the path info in the database because of the difficulties similar to the ones you are having.

hope this helps!
smbure