On Thu, 2005-05-12 at 07:21, Ian Harisay wrote: > If this takes 2 minutes then your problem is with your database, not > Perl. Which means you'll need to look at query optimization. Not code > optimization. Your query optimization may also include tuning your database.
Things like network latency, server loading, swapping and paging, and a few other things could also be the culprit. Could be more than one as well. Someone else has advised tracing the Oracle session, which would show you where the time is being spent. Jared
