I'm making a search page on my website and I have 3 different areas that need to be searchable.
Should I make an index table for each using MyISAM engine. Or should I just put the extra data inside of the previous tables using InnoDB?
MyISAM (separated index table)
- faster loading/search
- need to use CRON jobs to update it daily, same data in 2 places
InnoDB (all data in same table)
- data all in one place, easier to maintain, instant updating
- possibly slower loading times
Does anybody have any advice on this?