in reply to
Query takes 895ms in TOAD but 42s in DBI
Perhaps you are running the same thing in the two environments, but as different users, and one user does not have permission to use an index?
Comment on
Re: Query takes 895ms in TOAD but 42s in DBI
In Section
Seekers of Perl Wisdom