One MYSQL connection per function or big no no?

omegapandor · 11-11-2009, 02:58 PM

I'm currently learning how to make PHP and MYSQL be buddies. So far I've created a connection function and I use it in every other function in order to shorten the code.

Since I'm connecting to the MYSQL server (service on the apache server?) every single relevant function call, and I making huge overhead? Or is this normal behavior for talking with MYSQL?

Should I just call the connect function, run my other functions, and then close?

Thanks.

adamo · 11-12-2009, 12:53 AM

Theres no need to open up the connection for every function if you use them one after another.
Usually you can connect per script or if you use classes in PHP The Singleton Design Pattern for PHP

rafaelrls · 11-16-2009, 08:03 AM

Adamo answered it well man, too many connections causes an overload on the mysql server. it is better to use just one connection per session.

**Eric** · 11-16-2009, 08:18 AM

Originally Posted by adamo

Theres no need to open up the connection for every function if you use them one after another.
Usually you can connect per script or if you use classes in PHP The Singleton Design Pattern for PHP

I do something like that

PHP Code:

  class db

{

    private static $instance;

 
    private function __construct(...)

    {

        //

    }

 
    public static function getInstance()

    {

        if (!self::$instance)

        {

            self::$instance = new self();

        }

        return self::$instance;

????: NamePros.com http://www.namepros.com/programming/622489-one-mysql-connection-per-function-big.html
    }

}

 
$db = db::getInstance();

Of course there's a lot more to it than that.

11-11-2009, 02:58 PM	THREAD STARTER #1 (permalink)
omegapandor NamePros Regular Join Date: May 2008 Posts: 246	One MYSQL connection per function or big no no? I'm currently learning how to make PHP and MYSQL be buddies. So far I've created a connection function and I use it in every other function in order to shorten the code. Since I'm connecting to the MYSQL server (service on the apache server?) every single relevant function call, and I making huge overhead? Or is this normal behavior for talking with MYSQL? Should I just call the connect function, run my other functions, and then close? Thanks. __________________ Are you tired of viruses and popups? Use Firefox!

11-12-2009, 12:53 AM	#2 (permalink)
adamo NamePros Member Join Date: Aug 2008 Location: poland Posts: 94 Follow @depcore	Theres no need to open up the connection for every function if you use them one after another. Usually you can connect per script or if you use classes in PHP The Singleton Design Pattern for PHP __________________ web design/development

11-16-2009, 08:03 AM	#3 (permalink)
rafaelrls NamePros Member Join Date: Jan 2008 Location: me = new (live(in.paradise()) Posts: 174	Adamo answered it well man, too many connections causes an overload on the mysql server. it is better to use just one connection per session. __________________ portuguese portal de noticias opiniaoweb\| english generalities\|portuguese concursos publicos\|PharmaKnow \|pis pasep\|portuguese opiniaoweb carros\|portuguese tourism site

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)