我应该为网站的数据库使用哪种类型的引擎(InnoDB或MyISAM)? [英] what type of engine (InnoDB or MyISAM) should i use for my database for a website?

问题描述

我有一个具有gen/spec(继承性)的detabase ERD，并且大量使用了主键和外键.我打算用PHP开发我的网站，所以请帮帮我.回复.

I have a detabase ERD which have gen/spec (inheritance) and a lot of use of primary and foreign keys.i am going to develop my site in PHP ,So Please help me out.i wl b waiting for ur good replies.

tanx

推荐答案

如果您具有ERD(关系数据库建模术语)，那么您将没有"gen spec"，那么您将拥有Relationallly建模的Supertype-Subtype表.如果您具有通用规范"，那么您就没有关系数据库，那么您就有一个文件系统可以将对象持久化到该文件系统.那么，您拥有哪一个?

If you have an ERD (Relational Database modelling term) then you won't have "gen spec", you will have Relationallly modelled Supertype-Subtype tables. If you have "gen spec" then you don't have a Relational database, you have a filing system that you persist your objects to. So, which one do you have ?

如果您有一个关系数据库，那么肯定要使用InnoDB. MyISAM不是关系"的，因为没有声明性引用完整性等.

If you have a Relational Database, then definitely, go with InnoDB. MyISAM isn't "relational" since there are no Declarative Referential Integrity, etc.

如果您具有"gen-spec"，因为它不是关系型的，则不需要关系型功能或关系型引擎，MyISAM很好.实际上，您的C:驱动器就可以了.

If you have "gen-spec", since it isn't Relational, you don't need Relational capability or a Relational engine, MyISAM is fine. In fact your C: drive is fine.

这篇关于我应该为网站的数据库使用哪种类型的引擎(InnoDB或MyISAM)?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！