This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi, Is it possible to stream blobs with LightSpeed? From what I can see, blobs are converted into byte arrays, which means the entire blob would be loaded into memory. Unfortunately we are dealing with some very large blobs, so loading the entire blob into memory is tying up huge amounts of memory.
Craig |
|
|
|
|
It's not currently possible, but we could investigate it if it's critical for you. I can't make any promises though; the underlying ADO.NET infrastructure does have some limitations on streaming and it may not be possible for us to get around those in a transparent way. Don't forget you can lazy-load blobs so that they don't get pulled in unless they're actually being used. For example, if you need to present a list of videos, you wouldn't load the video data for presenting the list, only when the user selected to view the video. That may not help in your scenario, but I thought I'd mention it just in case! |
|
|
|
|
Thanks Ivan, We will use some stored procedures to stream the blobs, just wanted to make sure we weren't duplicating something that was already in place.
Craig |
|
|
|
