Mitch Pirtle <mitchy@spacemonkeylabs.com> said:
BUT, if you need speed, speed speed and don't need all the bells and whistles, MySQL simply cannot be beat. I have seen db-driven wesites with 10+ million visitors daily run on MySQL, and I am fairly certain that the same setup on PostgreSQL would require a few more boxen -;^>=
Well, it seems that SourceForge went from mySQL to PostgreSQL because the latter held better under high loads, and that PostgreSQL 7.1 beats mySQL hands down even under light load. Personally, I like PostgreSQL better because of the better concurrency and it feels more like a RDBMS should feel, with all them bells and whistles. I don't like the fact that a standard 'create table' under mySQL leaves you transactionless, either. That'll probably change, it's one big rat race between the two. Flip a coin and stick with it. OTOH, for my latest software I dropped PostgreSQL in favor of an object database (and Python for Smalltalk). YMMV. Film at 11. -- Cees de Groot http://www.cdegroot.com <cg@cdegroot.com> GnuPG 1024D/E0989E8B 0016 F679 F38D 5946 4ECD 1986 F303 937F E098 9E8B Building software is like quantum mechanics: you can predict what it will do, or when it will be ready -- but not both.