Re: Database choices
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