I am writing a web-app for my studies which includes fulltext search and foreign keys.
I have read somewhere, MyISAM engine is suitable for fulltext searching, and InnoDB
for foreign keys.
In this situation what engine should I use for the best performance?
- Why does MyISAM not support foreign key relationship but InnoDB does?
- Why does MyISAM support full text search but InnoDB does not?
Answers
- Kindly tell me, In this situation what engine I have to use for improve performance?
- The performance of each storage engine will depend on the queries you perform.
- However, be aware that different tables within the same database can use different
- storage engines.
- Why MyISAM engine does not support foreign key relationship and InnoDB does?
to implement foreign key constraints in MyISAM engine.
- Why MyISAM engine does support full text search and InnoDB does not? As documented under What Is New in MySQL 5.6:
- You can create FULLTEXT indexes on InnoDB tables,
- and query them using the MATCH() ... AGAINST syntax.
Therefore, full text search has been implemented in
InnoDB
as of MySQL 5.6.
0 comments:
Post a Comment