|
|
Posted by Fairul Izham on 08/09/06 03:46
"Erwin Moller"
<since_humans_read_this_I_am_spammed_too_much@spamyourself.com> wrote in
message news:44d8829f$0$4525$e4fe514c@news.xs4all.nl...
> 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
>
Haha... thanks a lot..
maybe I need to focus on fast query and redesign my database.
Do you think normalisation will help to speed up the query? I think, it only
help to reduce data redundancy which is able to get more spaces.
The more you normalise your database table, the longer n slower sql query
will be created. Humm.. is that right?
Navigation:
[Reply to this message]
|