Stuart Felenstein <[EMAIL PROTECTED]> wrote: > I have a slight dilemma. I am using transactions to > insert data into multiple tables. All but one table > is Innodb. That one is Myisam and it's left as such > because its one text column, so I want the benefits of > full text search. > > Still I need this transaction to somehow include this > entry. > Two thoughts : > 1- I created a temp innodb table and then after > transaction move the data over to the myisam. > > 2-Figure out what the text search options are in > innodb and maybe if there is a way to improve on them. > > Any suggestions ?
Consider LOCK TABLES: http://dev.mysql.com/doc/mysql/en/LOCK_TABLES.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]