List:General Discussion« Previous MessageNext Message »
From:Ed Lazor Date:September 28 2004 5:57pm
Subject:RE: Images
View as plain text  
Thanks for the article.  I'll check it out.

Throughput of 4600K/s is great.  How's latency?

-Ed


> -----Original Message-----
> So if the image was say 200K in size, the metadata for the image would
> be 1 row in a table, and the image data would be 4 rows in the data
> table.  3 full 64K rows + 1 partially used rows.
> 
> There is a good article/sample code here on the kind of technique we
> started with:
> http://php.dreamwerx.net/forums/viewtopic.php?t=6
> 
> Using chunked data, apache/php only needs to pull row by row(64k) and
> deliver to the client, keeping the resultset size low = memory
> overhead low.
> 
> The storage servers (mysql storage) I have tested on the LAN; them
> storing and retreiving data from mysql (using FTP gateway) at rates of
> 4600K/sec.. which is I think the fastest speed my laptop network card
> could deliver.
> 
> That's pretty fast..  Rare day when most internet users can talk to
> servers at those speeds.

Thread
ImagesGH28 Sep
  • Re: ImagesEric Bergen28 Sep
  • Re: ImagesJigal van Hemert28 Sep
    • Re: ImagesDreamWerx28 Sep
      • Re: ImagesGH28 Sep
        • Re: ImagesDreamWerx28 Sep
          • RE: ImagesEd Lazor28 Sep
RE: Imagesjabbott28 Sep
  • RE: ImagesEd Lazor28 Sep
Re: ImagesEric Bergen28 Sep
  • RE: ImagesEd Lazor28 Sep
  • RE: ImagesEd Lazor28 Sep
Re: ImagesDreamWerx28 Sep
  • RE: ImagesEd Lazor28 Sep
  • Multiple Insert Statement?Eve Atley28 Sep
    • Re: Multiple Insert Statement?GH28 Sep
      • Re: Multiple Insert Statement?SGreen28 Sep
    • Re: Multiple Insert Statement?Paul DuBois28 Sep
      • RE: Multiple Insert Statement?Eve Atley28 Sep
        • RE: Multiple Insert Statement?mos28 Sep
        • Re: Multiple Insert Statement?Rhino28 Sep
        • Re: Multiple Insert Statement?Rhino29 Sep
  • RE: ImagesEd Lazor28 Sep
Re: ImagesDreamWerx28 Sep
  • Re: ImagesGH28 Sep
    • Re: ImagesDreamWerx28 Sep
Re: ImagesDreamWerx28 Sep
Re: ImagesGH28 Sep
Re: ImagesDreamWerx28 Sep