+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Full Text Search / MyISAM and Transactions / InnoDB (/showthread.php?tid=27845)
Full Text Search / MyISAM and Transactions / InnoDB - El Forum - 02-22-2010
[eluser]mikepuerto[/eluser]
Hi,
I was hoping someone could offer some advice on how I should go about this. All of my current tables are currently MyISAM and I have a full text search on one of them. The tables all have some sort of relation and I would like to use CI Transactions to maintain them. The problem is that Transactions only supports InnoDB and full text only supports MyISAM.
What would you do? Create a separate, "searchable" table? If so, what would you do to manage that table being that I could not, insert/update/delete with transactions.
Thanks!
Mike
Full Text Search / MyISAM and Transactions / InnoDB - El Forum - 03-10-2010
[eluser]Ki[/eluser]
Look into Sphinx Search Engine ;-)