No subject

it is all the perl/mod-perl code.  I haven't yet looked at the source yet, but
(I'm probably teaching you to suck eggs here)  are you using one connection 
for all the SQL queries or opening and closing each one.   Also, are you using
placeholders for getting the ticket contents as this means you can reuse your
prepared SELECT statements.

I've not used Mason before so I need to get to grips with what thats up to
before I can really go poking into the source. 

Regards
Mark

-- 
Mark Vevers.    mark at ifl.net / mvevers at rm.com
Internet Backbone Engineering Team
Internet for Learning, Research Machines Plc
Tel: +44 1235 823380,   Fax: +44 1235 823424