Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re^4: Perl with Database connection.

by vinoth.ree (Monsignor)
on Aug 03, 2009 at 08:39 UTC ( #785393=note: print w/replies, xml ) Need Help??


in reply to Re^3: Perl with Database connection.
in thread Perl with Database connection.

Santhosh_89,

I support ping method man.

Update

Instead of connecting to the database every time when you execute the query, you connect with the database and by calling the ping method from DBI you can check the database connectivity, if the connection is alive, execute the query otherwise call the connect function and create database connection.

Replies are listed 'Best First'.
Re^5: Perl with Database connection.
by santhosh_89 (Scribe) on Aug 03, 2009 at 08:43 UTC

    Dear ree
    Ok,It is used for checking the connection is alive or not. I want to know which logic is better(global connection or multiple connection).I hope that you will understand now.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://785393]
help
Chatterbox?
[stevieb]: I went on my merry way writing a cross-platform, network-aware system that works across Perlbrew and Berrybrew systems and runs unit tests for Perl dists on all installed versions, with the ability to manage *brew commands themselves
[stevieb]: That worked out exceptionally well, as when I started that project, I hadn't delved into hardware development yet.
[stevieb]: found a issue in MetaCPAN::Client though today for my revdep tests. At least I think it's an issue
[stevieb]: I'm working on hiding the fact the software needs MetaCPAN::Client, as I often have a hell of a time installing it. I'm going to change it to let the user know if they do revdep that it needs to be installed, and remove that distribution ..
[stevieb]: ...from being a prereq

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (4)
As of 2017-06-25 23:33 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    How many monitors do you use while coding?















    Results (572 votes). Check out past polls.