On Thu, Jan 21, 2010 at 1:03 PM, Jake McGraw <jmcgr...@gmail.com> wrote: > On Thu, Jan 21, 2010 at 12:57 PM, Eddie Drapkin <oorza...@gmail.com> wrote: >> The bottom line is InnoDB is transactional, (configured properly) ACiD >> compliant, doesn't write-lock entire tables and supports foreign keys. >> Performance, next to these "features," isn't really a concern, IMO. >> >> On Thu, Jan 21, 2010 at 12:55 PM, Lester Leong <lester.ble...@gmail.com> >> wrote: >>> I'm sure we've all heard one version or another of which was faster. Among >>> the people I've spoken to in person the consensus was MyISAM. But I recently >>> came across a Falcon benchmark online that showed InnoDB being the fastest. >>> I'm sure the real answer is "it depends on your application", but... anyone >>> care to share their thoughts on this? > > InnoDB for everything but tables that require fulltext search, which > is not yet supported on InnoDB. >
That's what Solr (or Sphinx) is for ;) _______________________________________________ New York PHP Users Group Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk http://www.nyphp.org/Show-Participation