Re: FrontBase vs. MySQL performance comparisons?
Mike Schrag <[email protected]>
| Newsgroups | gmane.comp.web.webobjects.general |
|---|---|
| Message-ID | <[email protected]> |
The thing to keep in mind with MySQL is that you MUST use InnoDB or you're not going to get any of the features that you expect from a "real" database, but in doing so you sacrifice on the speed side and not all of the features that exist in ISAM exist in InnoDB yet. A couple of the things that were deal-breakers for me with MySQL: 1) you can only index a varchar up to 1024 bytes -- FrontBase doesn't have this restriction, 2) you can't use MySQL's full text index with InnoDB (FrontBase, obviously you have to buy theirs, though, but at least it exists). On the pro-FrontBase side, Geert and the folks at FrontBase provide awesome support. I'm consistently impressed with how quickly and thoroughly they respond to issues when I send them in. ms On May 26, 2005, at 12:16 PM, Brendan Duddridge wrote: > Hi, > > We have a WebObjects application that we'd like to eek some more > performance out of, so we're considering alternate choices for our > database server. I've always been a big proponent of FrontBase and > have used it on all my projects. However, in the interest of > increased performance, I was considering giving MySQL a try. Does > anyone already have any experience comparing the performance of > their WO applications running in FrontBase vs. MySQL? Are there any > other non-performance related issues that one should be concerned > about if switching from FrontBase to MySQL? Perhaps if someone has > a feature/performance comparison chart or similar document they > would like to share with the community, that would be awesome. > > Thanks, > > ____________________________________________________________________ > Brendan Duddridge | CTO | 403-277-5591 x24 | [email protected] > > ClickSpace Interactive Inc. > Suite L100, 239 - 10th Ave. SE > Calgary, AB T2G 0V9 > > http://www.clickspace.com > > _______________________________________________ > WebObjects-talk mailing list > [email protected] > http://www.omnigroup.com/mailman/listinfo/webobjects-talk >