Mailing Lists: Apple Mailing Lists
Image of Mac OS face in stamp
 
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Database choices

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
- Left join performance is bad
- Legacy left join syntax can return incorrect results
- OR performance is bad
- Multi-column indexes only allow a range of values for the last column of the index - resulting in bad performance
- 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.

John
 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/email@hidden

This email sent to email@hidden
References: 
 >Re: Database choices (From: Ricardo Parada <email@hidden>)
 >Re: Database choices (From: Mike Schrag <email@hidden>)



Visit the Apple Store online or at retail locations.
1-800-MY-APPLE

Contact Apple | Terms of Use | Privacy Policy

Copyright © 2007 Apple Inc. All rights reserved.