If you're slinging lots of uncomplicated data like this, you should use mySQL, no questions asked. The only way to get faster performance would be to use GDBM, but that's a little more difficult to get working for most folks.
On the other hand, for something as relationship oriented as a web site, you might find Postgresql working a charm with all it's rules, views, stored procedures, and triggers.