Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re: Re: DBI performance problem

by zeno (Friar)
on Jan 24, 2001 at 19:13 UTC ( [id://53992]=note: print w/replies, xml ) Need Help??


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

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://53992]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? • Last hour • Other CB clients
Other Users?
Others studying the Monastery: (1)
As of 2024-04-24 13:53 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found