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

I tried everything - from setting rowcachesize and using bind_columns and reading the DBD::Oracle documentation, but none of it made any difference. This is a seperate question as i am returning rows in a different way. The execute methods take a second which is fine, it is the fetch method that is taking the time. Thanks for the help.

Replies are listed 'Best First'.
Re^3: DBI Queries take half an hour
by runrig (Abbot) on Dec 16, 2008 at 20:33 UTC
    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?