Subject Re: [Firebird-Java] Re: Insert performance
Author William L. Thomson Jr.
On Fri, 2002-11-22 at 03:24, Roman Rokytskyy wrote:
> If your integrity constraints do not allow incorrect database state,
> you're on the safe side. No client can make any modification that
> will bring database into incorrect state. So, client simply inserts,
> updates, deletes and relies on the server to handle this correctly.

That's what I was thinking regarding the constraints but just wanted to
be sure.

> > > Is it good? I doubt...
> > Are you saying it's not good to use the built in features. Or not
> > good to not?
> It is definitelly good to use built in features. Yes, you will need a
> DBA for each database server you have (Oracle, DB2, MS SQL, Firebird,
> PostgreSQL, etc.). But you will be surprised how can you boost the
> performance of your application.

I am planning on sticking with Firebird unless I have a motivating
reason to use another. So I planned to start using features that may be
Fb specific.

Just wanted others thoughts on that. Most of my client side apps are in
Java. So I can use all the server side speed tricks I can get my hands
on, or have time/knowledge/skill to implement.

William L. Thomson Jr.
Support Group
Obsidian-Studios Inc.
439 Amber Way
Petaluma, Ca. 94952
Phone 707.766.9509
Fax 707.766.8989