I'm very green at OO perl, so I can't address the main topic . I would like to provide some perspective from the DBA side.

In an OLTP database, stored procedures, and triggers have to be very carefully done, or they can cause more performance problems than they solve. SP's and triggers can also cause a lot of headaches when the database is being replicated.

As DBA,I ask my perl folks to optimize their SQL and tell me the end requirement for delivery of the info. I'll opt tune indexes if needed and load balance large batch jobs to minimize impact on response time.

We now return you to princepawn's original topic...

Dave