Re: Default column value of MAX +1 of column - possible in Oracle 9i?

On Thu, 24 Mar 2005 19:56:33 +0000, wrote:

>
> Triggers are evil. They don't scale well and they make application
> changes more awkward, time-consuming and expensive.

Hmmmm. By implication:

It is better to lock the information, punt it across a network, look at the information, make a decision, punt the ressolved data back across the network, unlock the record. And this is more scalable, how?

And looking for the same - er, just similar - code in 15 different application components is less awkward than looking for one trigger.

I suppose the difference in thought process could be attributed to different experiences.

I've heard very similar arguments from people who have experience with a different RDBMS and are trying to do a single multi-platform fiasco, as well as people who really have not learned how to use triggers (or even databases) well - although they excelled in other languages.

But my experience indiocates exactly the opposite of your statement. IU'd appreciate you back up your comments with some stats.

/Hans Received on Thu Mar 24 2005 - 16:46:49 CST