Subject Re: [ib-support] Interaction with the database
Author The DeerBear
----- Original Message -----
From: "David Jencks" <davidjencks@...>
To: <>
Sent: Saturday, December 21, 2002 5:00 PM
Subject: Re: [ib-support] Interaction with the database

> "premature optimization is the root of all evil"

It's not only an optimization issue, to my opinion.

> I would expect using a stored procedure would produce a measurable speed
> difference primarily when it reduces the number of network or interprocess
> calls, which is not likely to be the case with a simple
> insert/update/delete.


> IMO, if the use of stored procedures improves your design, use them,
> otherwise measure the actual effect in a realistic environment.

It would probably greatly simplify it, giving me access to understandable
"InsertMessage" calls as opposed to "Insert into Messages..." calls that
must be
"localized" for each db engine I'd like to support.

In fact the application is being made with FB but I'd surely not dislike
being able
to support other RDBMS systems as well limiting changes on the client-side.

Would in this scenario the stored procs simplify the process?

I know that datatypes among RDBMS tend to be different, but I guess that on
the client side they tend to get more uniform as the programming language
used is always the same( Delphi ).

Do I make sense?

And, no, I won't be using DBExpress. At least not until all the supported
work without problems.

Beside everything, the first RDBMS I want to support is Firebird/Interbase.

> david jencks