On Wed, Sep 27, 2006 at 08:36:49PM -0400, Fred wrote: > On Wednesday 27 September 2006 09:36, Ben Scott uttered thusly: > > On 9/27/06, Fred <[EMAIL PROTECTED]> wrote: > > > MyISAM tables stinks when it comes to heavy updates, though > > > are wicked fast on the queries. > > > > There's a pretty direct cause-and-effect relationship there. > > > > You might want to look into more advanced database software. > > > > -- Ben > > Most of the tables are InnoDB tables; only table that is MyISAM is really the > one I need to use FullText with. > > However, it may be the case where I could use a more generalized search > system and tie that in to the rest of the system. There are two search open > source search engines that I know of; I should consider them.
Peter Zaitsev, formerly in the MySQL performance group, mentioned in his blog[1] today the full text storage engine SPHINX[2]. Probably worth a look. [1]http://www.mysqlperformanceblog.com/2006/09/27/life-beyond-mysql/ [2]http://www.sphinxsearch.com/ -marc -- Marc Nozell <[EMAIL PROTECTED]> http://www.nozell.com/blog _______________________________________________ gnhlug-discuss mailing list gnhlug-discuss@mail.gnhlug.org http://mail.gnhlug.org/mailman/listinfo/gnhlug-discuss