> Hi there, I am aware this isnt possible. I would like the power of Innodb, > but one of my applications also requires the boolean search within blocks of > text, how can i do this efficiently ?
I don't know what power of InnoDB you're referring to, but you can always use InnoDB for certain parts of your data and MyISAM for the texts you want to search with full text indexing. - transactions You can store the sensitive data in InnoDB table(s) and the texts in MyISAM; it's not very likely that blocks of text are sensitive for transaction influences - large tables Store the text in multiple tables. Simply find a way to break up your data in more than one table. - high concurrency. This can be a problem, but in most cases large amounts of texts are not inserted/updated very frequently. So in real life this will hardly be a problem. Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]