Re: FrontBase vs. MySQL performance comparisons?
Brendan Duddridge <[email protected]>
| Newsgroups | gmane.comp.web.webobjects.general |
|---|---|
| Message-ID | <[email protected]> |
Hi Mike, I agree with everything you said about FrontBase. I have absolutely no issues with Geert or with their high quality support. I am also a very big fan of their database. I am simply wondering if there are any better performing database engines that we "might" consider using. Your deal-breakers sound pretty serious to me, so I'll definitely take that into consideration and do some research. 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 On May 26, 2005, at 10:35 AM, Mike Schrag wrote: > 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 >> >> > >