>From: "George Pitcher" <[EMAIL PROTECTED]> > >I am about to start the planning process in moving my FileMaker/Lasso/PHP >site over to MySQL/PHP. > >Before I get too far down the road, should I be using InnoDB or MyISAM >tables?
InnoDB does not support FULLTEXT indeces. Since FileMaker searches are always full text, this may make a big difference in your particular case. If the user can do ad-hoc searches and the functionality must remain the same, you probably need to go with MyISAM. For example, searching for a last name of "Henry" will match "von Henry" and "O'Henry" in FileMaker and MyISAM (if last name is FULLTEXT), but will not in InnoDB. OTOH, MyISAM does not provide formal support for relations, like both FileMaker and InnoDB do. Your best bet may be to have a hybrid approach, where all your fields that require full text searching are segregated into MyISAM tables, and use InnoDB for everything else. ---- SQL SQL SQL SQL ---- -- : Jan Steinman -- nature Transography(TM): <http://www.Bytesmiths.com> : Bytesmiths -- artists' services: <http://www.Bytesmiths.com/Services> : Buy My Step Van! <http://www.Bytesmiths.com/van> --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
