|
|
Posted by J J on 04/17/05 02:43
Hmmm... not sure how this is done. I see someone
added an example that they use substring to load 10mb
of data at a time from the blob.
The part I don't understand is how they loop the
statements and continue to stream data to the user.
If I make one pass and get 1mb of the blob...the
browser is simply going to load that 1mb only, right?
How do I keep looping and refreshing the users
browser, or in this case, flash player?
Thanks for any ideas!
--- Marek Kilimajer <lists@kilimajer.net> wrote:
> 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
>
__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/
Navigation:
[Reply to this message]
|