Generalization Hierarchies with MyISAM
Posted by:
jamchg
Date: July 24, 2006 05:12PM
Hi,
I am new to MySQL. I was wondering if using generalization/specialization hierachies are recommended for MyISAM tables in MySQL. I understand that there is no recursion in MySQL which would be nice to have for parent/child relationships. Also, since I am using MyISAM tables, concurrency would at times involve locking a parent and some of its children (locking many tables vs. locking a single table when hierarchies are not used). Would it be better to not use hierarchies?
Thanks. Any help is very much appreciated.
Subject
Views
Written By
Posted
Generalization Hierarchies with MyISAM
2517
July 24, 2006 05:12PM
1663
July 31, 2006 02:21AM
2796
August 04, 2006 02:29PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.