On Friday 26 January 2007 06:17, Olaf Stein wrote: > From a feature perspective, I do not need full text indices,
This is about the only reason I've seen MyISAM promoted as table engine of choice. > I know this is a very general question but it seems not to make any sense > not to use innodb having such exotic features like foreign keys and > transactions. Foreign keys, imho, are a really good thing for a database. While they may not seem terribly important at first, consider your statement of "(if I write the applications accordingly)". I note the plural here and point out that foreign keys would centralize your data referencing, so you could write your application in 10 different languages and the data relationships would still say the same. Given the somewhat heterogeneous web development environment people see today (I've seen PHP and Java for example), it makes it a good idea as any to use the table. Another thing to consider is: -- Chris White PHP Programmer Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]