in reply to DBI Queries take half an hour

You asked that question before. Which of the answers did you not understand? What did you try?


All dogma is stupid.

Replies are listed 'Best First'.
Re^2: DBI Queries take half an hour
by joec_ (Scribe) on Dec 16, 2008 at 11:23 UTC
    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.
[reply]
      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?
[reply]

In Section Seekers of Perl Wisdom