On Thursday, Aug 28, 2003, at 13:46 Europe/Amsterdam, Chris Nolan wrote:
Hi,
ISAM and MyISAM are venerable but it looks as if even MySQL AB
themselves are relying heavily on InnoDB. The fact that we can have
foregin keys now with InnoDB is
a massive benefit (MyISAM won't get this until it's implemented for
all table types, which is slated for MySQL 5.0).
Foreign keys are pretty useful indeed. Waiting for MySQL 5.0 could take
quite long i guess ;)
There is one advantage that MyISAM tables have, and that's their
FULLTEXT index capabilities.
That's an important point for DBmail.. Hadn't thought of that.
cheers,
Ilja
