Re: Database choices
Re: Database choices
- Subject: Re: Database choices
- From: Chuck Hill <email@hidden>
- Date: Mon, 29 Oct 2007 13:29:52 -0700
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 (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:
This email sent to email@hidden