in reply to Re: DBI performance problem
in thread DBI performance problem

Dear TadMan,

You are right! I moved the connect and disconnect out of the function and performance flies now. It was taking about 5 minutes to process 116 records before and now it's around ten seconds.

I found that it didn't like me using prepare_cached with the same database handle (it complained that "Data type for parameter 1 has changed since first SQLExecute call", so I'm using prepare instead. Still, performance is blazing now.

I'll see if I can create the library you speak of. Thanks a lot. -timallen

Replies are listed 'Best First'.
Re: Re: Re: DBI performance problem
by Fastolfe (Vicar) on Jan 24, 2001 at 20:13 UTC
    You might be interested in noting that by removing the DBI connect call, if your function has no need to process returned rows (such as via a 'select' statement), your function is then somewhat equivalent to the 'do' method in DBI.
[reply]
      Dear Fastolfe,
      You're right, too. I'll see if I can use do instead on my inserts and updates. Thanks, I really appreciate all of the input I've gotten. -timallen
[reply]

In Section Seekers of Perl Wisdom