in reply to Re^2: DBI Queries take half an hour
in thread DBI Queries take half an hour

Are there indexes? Do you have permission to use the indexes? Did you get a query plan? Do TOAD and perl/DBI have the same query plan?