Re: Streaming video BLOBs from MySQL

J J wrote:

I have a case where video files (mov, flv, etc) have been stored in a MySQL database as blobs. I'm loading them into a flash video player and everything works fine except it takes longer it seems and it doesn't allow streaming the actual video. If I load the same videos with a direct link to the http:// file system (/videos/file.flv) it loads in super-fast and allows streaming. I'm guessing mysql and/or php doesn't actually release the BLOB until it's loaded it completely. So, is there a way to actually have PHP read the BLOB and stream it as it's loading? Is there an fstream() option like the fread()?

use mysql's SUBSTRING() function in a loop