Re: FrontBase license now free!
Re: FrontBase license now free!
- Subject: Re: FrontBase license now free!
- From: "Pierce T. Wetter III" <email@hidden>
- Date: Thu, 4 May 2006 09:42:05 -0700
- Doesn't use index with or-clauses.
I seem to remember this getting fixed quite awhile ago (3.x ish?).
Are you still running into it? I know it was definitely fixed for the
common EOF case you're probably thinking about.
- Has problems with some types of joins (extremely slow).
Sure, that's true of all databases, even Oracle/DB2/etc.
We had also issues with crashes sometimes without being able to
reproduce it.
Oracle crashes too...FB recovers faster in my experience.
FYI, if you turn on SQL logging, FrontBase has a tool that will
replay your SQL operations in order, and they can use that to fix the
bug pretty quickly. We've gotten them to fix some obscure bugs (1
every 10,000,000 database operations) that way. Uptime on our
database is now measured in months...
This should not say, that I don't like Frontbase - I use it in
several projects and know the advantages. But I know the
disadvantages as well.
There you go, I agree.
Personally, the biggest advantage for me is very subtle: Because
there's a one to one mapping between FB types and Foundation types,
there's no "impedance mismatch" between the database and your code.
So if you write a value to the database, and read it back, you get
the same answer. That's not always the case with some datatypes and
other databases. This is especially a big deal with optimistic
locking and EOF.
Pierce
_______________________________________________
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