BLOB to Video

[JamesU2005]

All,

I have stored a WMV Video file in a Blob format in a MySQL database.

What I want to do now is to be able to insert a link into a Object class so I can stream the video. You know the embeded Windows Media Players.

What I have setup in the MySQL is one row called 'videoname' is the actual file name so i.e. thisismyvideo.wmv

The row named 'size' is how big the file size is. The 'type' named row stores the type of file the video is so video/x-ms-wmv. Then finaly there is another row called 'content' that is the actual BLOB.

So Would this be possible?

 

[marc2003]

one question. why?

seriously, that's just plain daft. store the files on disk and keep the file details in the database.

i've messed around with blob fields just to store images and the performance hit was huge - and this was tested on my own pc. i'd hate to think what videos would do on a remote server......

 

[Moredhel]

Yeah, my comic manager originally stored the images as blobs in the DB, the DB ended up huge and slow after a couple of hundred records. I ended up moving to storing the images on disk and referencing them from info in the DB. It sped it up a LOT and it's still instant with nearly 10,000 records in the DB.