Mysql Complicated Relations
Posted 29 May 2006 - 09:20 PM
I'm curious to learn how is mysql with relations. But I'm not talking about simple ones. I'm intended to learn how is it's perfomance when realtions get complicated (like a relation with b, b relation with c, c relation with d and go on...) and relation numbers and db size increase a lot, can I ecnounter any problems? Or any bugs can occur like broken relationships or nothing happens instead of an operation with relations.
What kind of problems can I encounter using mysql in a big project. What are the differences of InnoDB and MyISAM in a big project. What are they advantages. Why should I choose one of them?
Posted 30 May 2006 - 04:57 AM
As far as broken relationships, it's up to you -- InnoDB can enforce FK constaints, while MyISAM does not. There are arguments to be made for both; it really depends how your tables will be used (mostly reads vs writes).
Hope that helps a bit.
Posted 30 May 2006 - 07:42 AM
And yes your post really helped a lot At least now I don't worry about my choice. Thanks
Posted 31 May 2006 - 06:32 AM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users