site for advantages and disadvantages of mysql 1

[Guest_imported]

hi guys,
i'm doing a research on mysql. i could find a lot of advantages of using mysql. but i do believe it has it's own advantages. where could i find more information regarding this matter? thanks for the help.

from,
steve

 

[rycamor]

A few disadvantages of MySQL in order of descending importance:

1. Table-level locking instead of row-level locking
2. No sub-selects
3. No foreign key constraints
4. No stored procedures
5. Transaction support is still in beta stage

Advantages:

1. One of the fastest performers for multiple reads, (table-level locking slows multiple writes)
2. Easy to use and install, cross-platform
3. Progressing fast toward fixing above disadvantages

One open-source database that has more sophisticated features, such as transactions, sub-selects, stored procedures, etc... is PostgreSQL, at

http://www.postgresql.org,

although it's raw performance doesn't seem to be quite as fast as mysql (except for multiple writes).