Re: Database choices
Re: Database choices
- Subject: Re: Database choices
- From: Chuck Hill <email@hidden>
- Date: Tue, 30 Oct 2007 10:01:46 -0700
On Oct 30, 2007, at 7:31 AM, John Huss wrote:
We use FrontBase for an application that does mostly large, complex
queries (aggregating data, etc). A few things about FrontBase have
bothered me and made me consider switching to Postgres:
- The database process crashes sometimes due to various queries
that it doesn't like
Usually this is a parser bug and they have always fixed them
quickly. But it is definitely not something you want to find on an
app in production.
- Left join performance is bad
- Legacy left join syntax can return incorrect results
- OR performance is bad
Yes, something odd is going on there.
- Multi-column indexes only allow a range of values for the last
column of the index - resulting in bad performance
I have not run into this one. Can you elaborate on this?
- Adding columns to large tables can take hours and makes the DB
unresponsive
So I would say that FrontBase is great for applications that do
simple, fast queries, but maybe not if your needs are more demanding.
Chuck
--
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