Posted by Marek Kilimajer on 10/05/01 11:14

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

[Back to original message]