Hi,
I am designing a new db for my website.
It is a database of events with the following tables.
Events
Category
Owners
Countries
Regions
Subregions
I am left with the following dilemma,
I use foreign keys to ensure fast links between the table Events and other tables (category, countries,...)
this means using InnoDB
Now I want to have the abillity to use fulltext search on the table Events but that would mean using Myisam.
How do I fix this?
Also, using Myisam would eventually result in waiting periods as it would use lock table instead of lock row.
anny suggestions?