Welcome Guest, Not a member yet? Register   Sign In
Full Text Search / MyISAM and Transactions / InnoDB
#1

[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
#2

[eluser]Ki[/eluser]
Look into Sphinx Search Engine ;-)




Theme © iAndrew 2016 - Forum software by © MyBB