September 2, 2008 at 6:35 am
Hi All
I have a Image data type on SQL 2005, there are around a million rows on the table, i need to get a video that is stored on the table using a key, that key is indexed, when i retrieve a record from the server which holds data, it takes me less than a second, but if i am retrieving it from a remote server it takes me more than 2 seconds.
This image is used for streaming, how does SQL reacts to streaming, does it loads the data completely on cache and then starts streaming, else it loads only the first bit for streaming and then starts to load the rest
Does any one faced problem like this before, please shed me some light on this issue.
Cheers
🙂
September 2, 2008 at 7:57 am
I don't know how SQL Server handles streaming, but I do know that it will be likely that bringing a large image file across the network using SQL will take time. When storing Images/Text/Documents in SQL Server the recommendations I have read is to only store smaller files in SQL Server and larger files on the file system with only a path in SQL Server.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply