I could go on about dependencies on your data (1 image or many rows), your indexes (very important for queries per second), your web server, etc.
But I think you are more interested on if it can be done with MySQL. YES, it can. I was just reading yesterday about Yahoo's switch to PHP and the performance problems they had with remember.yahoo.com (?). That was there first big project using PHP, MySQL, Apache. At first, MySQL got crushed by the load. They added something like 20 more MySQL slaves which then got things working under heavy load.
Their hind site analysis was interesting. A big part of the reason MySQL "failed" was poor database design and lack of indexes on key fields. Join fields were not indexed!
On Thursday, October 31, 2002, at 09:10 AM, Benji Spencer wrote:
This leaves one major question. How much data can MySQL push out? Can MySQL handle 12.5 megabytes (not megabits) per second of data? Will MySQL handle 20 queries per second?
-- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php