From: Benjamin L. <ben...@co...> - 2001-05-04 15:12:21
|
This is just a thought... I was going through the code, and I was wondering to myself whether it would robustify matters any to move the 'update_balance' code into the database layer with triggers and then have the 'chart' table updated by the triggers. Using triggers would of course put MySQL in a bit of a muddle, but it would simplify the business processes in the application layer. I was almost confused reading the bits between old_this and new_this. ;-) I might stuff around with this trigger idea in the not too distant future. Comments? P.S. Don't flame me about MySQL. I love MySQL; and in fact, I'm more of a newcomer to PostgreSQL. I'm just poking around and the like. -- B. http://makelinux.org/ "Always real." http://realthought.net/ |