• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Database choices
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Database choices


  • Subject: Re: Database choices
  • From: Christian Trotobas <email@hidden>
  • Date: Tue, 30 Oct 2007 06:02:32 +0100

I have been using FB since it was in beta, and never ever had a single problem. It is my dev base of choice.

It is very fast, scales very well; and I like the slick UI and the sql92 compliance. For those whom might have the need, the FB support is the most responsive I've ever seen.

Oracle 10g is very impressive while the RAC performs a lot, even with a high ratio of write/read; of course, not the same universe of pricing and so on. FB works with a few clicks in a package installer, and I forget it: just works.


Christian Trotobas

http://intellicore.net


Le 29 oct. 07 à 21:29, Chuck Hill a écrit :


On Oct 29, 2007, at 11:40 AM, Mike Schrag wrote:

I suspect they very likely have compelling performance numbers, but I haven't had time to actually run tests with our real databases on it ...

The best database for a particular application really seems to depend on the size of the database and the exact mix of transactions. Here are some interesting numbers that Georg Tuparev posted a while back:
According to my notes, the speed of MySQL start degrading by about 30-40GB load. The number of records did not worsen the situation for simple (one table) fetches, but joins start getting slower. I do not remember the number of records though. At about 100GB MySQL was dead.

In contrast FrontBase was not shining up until 40-50GB when it start getting the bests marks. We stopped our loads at 1.7TB. At that stage only FrontBase and Oracle were working normally and PostgresSQL was struggling (later version of it work much better, but we never tested them extensively). With 1.7 TB and 470M records in the most populated table (about 300 tables in total) FrontBase was doing on average 30% better then Oracle.

If you count price, support, and maintainability, FB is probably two orders of magnitude better then Oracle. I believe only the current version of PosSQL should be considered seriously ... but the support FB gives outweighs the small price we have to pay for it.


There are graphical MySQL front-ends (whereas FB's is fine, but sort of "passable"), and honestly there are pkg installs of it also at this point, so it's not a WHOLE lot more than double-click- to-install at this point. Slightly more obnoxious with permissions and users, etc, I suspect. I think FB wins pretty handily in the competition from zero-to-running-database, but how often are you doing that part? In terms of % of time spent, that's only a fraction of your db's life. I just don't want to discount it because a decade ago it sucked.

All good points. If it was not for the clustering / replication, I probably would not look at. When you add that need, it is one of the contenders.



Chuck



On Oct 29, 2007, at 2:22 PM, Chuck Hill wrote:

I am sure that you can make it go, but other than clustering, why bother? If you don't need that it seems like a lot of configuration work, research, etc. for what FrontBase gives you with a single click installer.

Chuck

On Oct 29, 2007, at 10:40 AM, Mike Schrag wrote:

You know, I have thought this same thing of MySQL for years, but I think it's because I'm evaluating it based on its feature set from 1998 and not giving it a fair shake. I've read a lot of stories on, for instance, highavailability.com about huge sites that use it. I'm not too keen on the restriction that clustering is in-memory only, but it actually seems like a legitimate database these days (ONLY with InnoDB). It's on my list of things to evaluate more fairly :)

ms

On Oct 29, 2007, at 1:16 PM, Chuck Hill wrote:

I am with Mike on this. If you just need free, FrontBase is hard to beat. If you must have open source, PostgreSQL. MySQL has some nice features, but... I dunno, it is still MySQLToy to me.

Chuck


On Oct 29, 2007, at 9:52 AM, Mike Schrag wrote:

I prefer FrontBase ... It's trivial to setup, runs very well, and it's free. MySQL and PostgreSQL are obvious other choices as well.

ms

On Oct 29, 2007, at 10:23 AM, Ken Foust wrote:

Using Leopard > Eclipse > WOLips - which is the database of choice. I have heard postgres is the best of the opensource ones. But which one works best with replacement tool for EOModeler?
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects- email@hidden)
Help/Unsubscribe/Update your Subscription:
40mdimension.com


This email sent to email@hidden


_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40global-village.net


This email sent to email@hidden


--

Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
http://www.global-village.net/products/practical_webobjects








_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40global-village.net


This email sent to email@hidden


--

Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
http://www.global-village.net/products/practical_webobjects








_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40global-village.net


This email sent to email@hidden


--

Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
http://www.global-village.net/products/practical_webobjects






_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40mac.com


This email sent to email@hidden

_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (email@hidden) Help/Unsubscribe/Update your Subscription: This email sent to email@hidden
References: 
 >Database choices (From: Ken Foust <email@hidden>)
 >Re: Database choices (From: Mike Schrag <email@hidden>)
 >Re: Database choices (From: Chuck Hill <email@hidden>)
 >Re: Database choices (From: Mike Schrag <email@hidden>)
 >Re: Database choices (From: Chuck Hill <email@hidden>)
 >Re: Database choices (From: Mike Schrag <email@hidden>)
 >Re: Database choices (From: Chuck Hill <email@hidden>)

  • Prev by Date: Re: Database choices
  • Next by Date: Re: Database choices
  • Previous by thread: Re: Database choices
  • Next by thread: Re: Database choices
  • Index(es):
    • Date
    • Thread