|
|
Posted by Erwin Moller on 08/08/06 12:25
Fairul Izham wrote:
>
> "Erwin Moller"
> <since_humans_read_this_I_am_spammed_too_much@spamyourself.com> wrote in
> message news:44d0b41a$0$4531$e4fe514c@news.xs4all.nl...
>> Fairul Izham wrote:
>>
>>> Hi experts,
>>>
>>> Need some opinion,
>>>
>>> in my script, I create 3 database connection looks like this
>>>
>>> $db[1] = mysql_connect($server2, $username2, $password2, TRUE) or
>>> die("Server ".$server2." not found");
>>> mysql_select_db($database2,$db[1]) or die("Database ".$database2." not
>>> found");
>>>
>>> $db[2] = mysql_connect($server3, $username3, $password3, TRUE) or
>>> die("Server ".$server3." not found");
>>> mysql_select_db($database3,$db[2]) or die("Database ".$database3." not
>>> found");
>>>
>>> $db[3] = mysql_connect($server4, $username4, $password4, TRUE) or
>>> die("Server ".$server4." not found");
>>> mysql_select_db($database4,$db[3]) or die("Database ".$database4." not
>>> found");
>>>
>>> it is nicely deployed on busy webserver?
>>
>> Hi,
>>
>> What is your question?
>>
>> If you are wondering if making 3 connections is a problem: No.
>> Be sure you mention which connection each time you use one, because PHP
>> will
>> use the last one if you ommit the connectionparameter. A nice source of
>> potential bugs. :-)
>>
>> Regards,
>> Erwin Moller
>
> humm...
>
> mysql_connect ( [string server [, string username [, string password [,
> bool new_link [, int client_flags]]]]] )
>
> is it the connection parameter you mean is "bool new_link" ?
Hi,
I was away a few days. :P
No, that is not what I ment.
With the mysql_connect you MAKE a connection and store that reference in
some variable.
When EXECUTING some query you can say on which connection.
(Check the docs at www.php.net.)
That is where you should take care to use the right one. If you ommit it PHP
will use the last one.
> what i'm wondering is, if webserver open to many connection to mysql
> database, it will degrade the mysql database performance. I also think is
> it possible the mysql server will return error "to many connection" to
> webserver. when i try the code on my pc it's seems okey, but what happen
> when I use it on busy server. is there any possible issue will come out?
Yes, theoretically you could be the one that uses the last available
connection(s).
I wouldn't worry about that too much.
There is little overhead involved in making connection, true, but do not
think it is a lot. (I heard estimates of 2K per connection for mysql, not
sure excactly, but nothing to make fuzz about.)
In general the quality of your databasedesign and the quality of your
queries is of MUCH more importance than the fact you use 3 connections.
My advise would be: Focus your energy on good databasedesign. Understand
foreign keys, normalisation, etc. It helps you and the quality of your
applications a lot more, really. :-)
Hope that helps.
Regards,
Erwin Moller
Navigation:
[Reply to this message]
|