I'm a newbie to database technology and would like to consult some questions about optimising database.
I have 2 senario:
Senario 1:
I have a database server where every database will have its username and password to access. However, each time when I need to access different database, I need to set up another connection with its own username and password. I wonder will it overload the server when too much connection be made at a time ?
Senario 2:
One username and password for all databases in the database server. This is much faster I suppose but in security sense, it 'll be quite risky that somebody might *mistreating* other database's information.
Which aspect should I look into when dealing with optimising database performance ?
Thank you for helping =)
I have 2 senario:
Senario 1:
I have a database server where every database will have its username and password to access. However, each time when I need to access different database, I need to set up another connection with its own username and password. I wonder will it overload the server when too much connection be made at a time ?
Senario 2:
One username and password for all databases in the database server. This is much faster I suppose but in security sense, it 'll be quite risky that somebody might *mistreating* other database's information.
Which aspect should I look into when dealing with optimising database performance ?
Thank you for helping =)