In the last episode (Apr 02), Gavin Towey said: > I disagree. There's nothing about his requirements that sounds like > MyIsam is a better solution. InnoDB should be your default for all > tables, unless you have specific requirements that need myisam. One > specific example of an appropriate task for myisam is where you need very > high insert throughput, and you're not doing any updates/deletes > concurrently. > > You want the crash safety and data integrity that comes with InnoDB. Even > more so as your dataset grows. It's performance is far better than myisam > tables for most OLTP users, and as your number of concurrent readers and > writers grows, the improvement in performance from using innodb over > myisam becomes more pronounced.
His scenario is "perhaps updated once a year", though, so crash recovery and multiple writer performance is not important. -- Dan Nelson dnel...@allantgroup.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org