Hi Jan - That's a project that I'd like to hear more about. I'm very much interested in clustered and replicated installations, and would love to hear more about your experiences. I've been theorizing that having the images in the database means that without caching, you're essentially looking at a database hit and a pretty significant open data stream from the database for each image served, but it's not every day that you get to test that kind of thing out in the wild. I'd love to hear about some first-hand experiences with that setup in a real-world setting -- I'm sure it would be educational.
I changed jobs a few months ago, and I'm actually working as a whitebox qa engineer at an established digital photo company these days. Our product is in use by millions of end users, and the number of photos on the service greatly exceeds your benchmark of 1,000,000 images. I'd be happy to get into the specifics off-list if you're really interested, but the assertion that I'm basing my opinion on experience with small-scale instalations isn't true. I get to play with the guts of the service in the lab, and I get to watch it's performance daily, in a real-world, prime-time setting. I'm not saying that other approaches aren't valid -- but I do know first-hand that this approach works in a large-scale installation. I also feel good about the fact that a team of highly-talented and experienced engineers came to the same conclusion long before I joined their team. -Jeromie >... there are certain advantages to having your images stored in the >database when it comes to ease (and speed) of backup, federation and >distribution over multiple servers, ease of import/export, and other >aspects. > >Note that some of these issues become much more important with HUGE >databases. Imagine distributing file-system-based images across a >dozen distributed database servers. > >If all you have is a hammer, all the world looks like a nail. People >who make observations based on a few images can't speak with any >authority about 1,000,000 images. > >:::: We got the best politicians in this country that money can buy. >-- Will Rogers >:::: Jan Steinman <http://www.Bytesmiths.com/Item/99AA34> > > > > >The php_mysql group is dedicated to learn more about the PHP/MySQL web >database possibilities through group learning. >Yahoo! Groups Links > > > > > > > > The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
