>> I don't know what your data or your needs are, but I just thought I'd >> make you aware of this; MySQL is *not* the answer to a great many >> problems, regardless of the storage engine. Use the right tool for >> the job. > > Right. I've used other databases that were faster than MySQL for some > queries, but they can't load more than a couple million rows because of > their high index maintenance. > MyISAM is the only engine I've found that can load a lot of data (50 million > rows) in just a few minutes and rebuild indexes in no time. It looks like > I'll stick with MyISAM.
Of course, if indexing is the major challenge, it could also be that you'd benefit from something like Tokutek (or Infobright, which doesn't really have indexes in the traditional sense). But I don't know what Tokutek's price is, or if they'd be suitable for your application. And then you'd be able to stay within the umbrella of MySQL, which is a huge advantage. I guess it all depends how you value the price-benefit ratio of getting more from your hardware, vs. proprietary licensing fees, vs. building things your own way. This has all gone far afield from NitroEDB :-) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
