On Jan 13, 2010, at 3:11 PM, Travis Britt wrote:

Yeah I'm doing this, everything is InnoDB except for a read-mostly (as in, write once in a blue moon) table that's MyISAM due to InnoDB's row size limit

Row size limit?  Oooh, tell me more!  ;-)



and the fact that it's currently got a ton of varchar(255) columns.

On Jan 13, 2010, at 4:01 PM, David LeBer wrote:
I know it's ugly, but you can mix InnoDB and MyISAM tables in the same database.

If the FULL TEXT indexes are only on a single/few tables/columns that may be an option.

Keep MyISAM for the FT tables, move everything else to InnoDB.

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net

This email sent to [email protected]

--
Chuck Hill             Senior Consultant / VP Development

Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
http://www.global-village.net/products/practical_webobjects







_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to