• 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: 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


  • Follow-Ups:
    • Re: Database choices
      • From: "John Huss" <email@hidden>
    • Re: Database choices
      • From: Guido Neitzer <email@hidden>
References: 
 >Re: Database choices (From: Ricardo Parada <email@hidden>)
 >Re: Database choices (From: Mike Schrag <email@hidden>)
 >Re: Database choices (From: "John Huss" <email@hidden>)

  • Prev by Date: Re: Thank you for your comments
  • Next by Date: Re: The Official What-I-Did-To-Run-5.3-On-Leopard Post
  • Previous by thread: Re: Database choices
  • Next by thread: Re: Database choices
  • Index(es):
    • Date
    • Thread