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 | ||
---|---|---|
• Images | GH | 28 Sep |
• Re: Images | Eric Bergen | 28 Sep |
• Re: Images | Jigal van Hemert | 28 Sep |
• Re: Images | DreamWerx | 28 Sep |
• Re: Images | GH | 28 Sep |
• Re: Images | DreamWerx | 28 Sep |
• RE: Images | Ed Lazor | 28 Sep |
• RE: Images | jabbott | 28 Sep |
• RE: Images | Ed Lazor | 28 Sep |
• Re: Images | Eric Bergen | 28 Sep |
• RE: Images | Ed Lazor | 28 Sep |
• RE: Images | Ed Lazor | 28 Sep |
• Re: Images | DreamWerx | 28 Sep |
• RE: Images | Ed Lazor | 28 Sep |
• Multiple Insert Statement? | Eve Atley | 28 Sep |
• Re: Multiple Insert Statement? | GH | 28 Sep |
• Re: Multiple Insert Statement? | SGreen | 28 Sep |
• Re: Multiple Insert Statement? | Paul DuBois | 28 Sep |
• RE: Multiple Insert Statement? | Eve Atley | 28 Sep |
• RE: Multiple Insert Statement? | mos | 28 Sep |
• Re: Multiple Insert Statement? | Rhino | 28 Sep |
• Re: Multiple Insert Statement? | Rhino | 29 Sep |
• RE: Images | Ed Lazor | 28 Sep |
• Re: Images | DreamWerx | 28 Sep |
• Re: Images | GH | 28 Sep |
• Re: Images | DreamWerx | 28 Sep |
• Re: Images | DreamWerx | 28 Sep |
• Re: Images | GH | 28 Sep |
• Re: Images | DreamWerx | 28 Sep |