BorlandTalk.com

GB · Guest

Hi

I am a fairly experienced Delphi / Database developer and have pretty much
always used the client/server model. I am also a fan of stored procedures
and tend to perform all database access through them (SQL Server)

I am often tempted to get on the multi-tier bandwagon, but whenever I give
it a try I always end up thinking it's a pain in the a**. Maybe I'm doing
something wrong, maybe I don't understand the concepts fully.

One big problem is the SQL code. Do people REALLY use Query objects and
compile their sql code into COM+ objects, using that little property editor.
In my experience the sql is the part which changes the most. If you use
stored procs. no need to recompile anything, just run a script on the DB
server.

There also seem to be big headaches associated with error handling and
enforcing security.

In my mind multi-tier is a lot more work than the more traditional models. I
have heard all the arguments about database independence and scalability,
but I would guess that a BIG percentage of multi-tier projects will never
benefit from these.

Perhaps someone would be kind enough to educate me.

regards

Gary Barwick