From: Jerry Sievers Date: 2004-04-21T21:19:17+09:00 Subject: Re: The quest for opensource database... "Tony Marston" writes: > You do not need stored procedures or database triggers to write successful > applications. I once had to maintain a system that was built around > procedures and triggers, and it was a nightmare. The problem was that one > trigger/procedure updated several tables, which fired more triggers which > contained more updates which fired more triggers ..... It was impossible to > keep track of what was being fired where. Right! Gratuitous use of triggers, SPs and the like results in indirection that can make a system impossible to understand. Use with care. But is this a vote in favor of a less advanced system that prevents the temtation? I don't think so. YMMV -- ------------------------------------------------------------------------------- Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant 305 321-1144 (mobile http://www.JerrySievers.com/ -- ------------------------------------------------------------------------------- Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant 305 321-1144 (mobile http://www.JerrySievers.com/