ads' corner

some tests from tweakers.net

tweakers.net has again tested the performance of PostgreSQL 8.2-dev and MySQL 4.1.20 and MySQL 5.0.20a. Results are nice and shown here.

Best thing: the collapse for requests per seconds if MySQL has a concurrency greater than 7. Oh, and by the way, they don’t state the table type for MySQL so we don’t know, if it is the fast and forgetfully MyIsam or the better but slower InnoDB type.


Rasmus Lerdorf is praising PHP ...

Rasmus Lerdorf, the creator of PHP, tells us (here), that the web is broken and “we” had damaged it. But there would be PHP, which can fix all the issues. Ok, let’s see what Rasmus has to tell us.


MySQL and Foreign Keys

If you ever try to use Foreign Keys in MySQL (of course, only the InnoDB engine supports this), don’t forget, that the columns in both tables must have exactly the same definition.