Multiple mysql connections

andy75180

Hi,

I'm currently in the early stages of designing a member login section for my website. Each member would have the usual username and password login and then the user tracked with a session.

Once logged in, members will be accessing data from the database a lot, pretty much on every page they click on.

Can anyone advise on what is the most efficent way of connecting to mysql for each of my users, even when lots of them are logged in at the same time?

Would it best to just use 1 connection to the database and use this with each member or create a different connection for each member? And also what about persistant connections?

Any help would be most appricated.

Andy

NogDog

If you use the usual MySQL connection commands([man]mysql_connect[/man] or mysqli_connect), any given connection will last, at most, until the script exits. This is probably your preferred behavior, as certain functions such as [man]mysql_insert_id[/man] are connection-dependent, and if you were to try using a persistent connection (e.g. [man]mysql_pconnect[/man]) you could run into more problems than whatever minor performance improvement - if any - it might provide.

andy75180

Okay thankyou. I will use 'mysqli_connect' to access the database.

But what will happen if two different members are accessing this script at the same time?

HalfaBee

Not much, most hosts allow a reasonable number of concurrent connections,
The connection using mysql_connect will only last as long as it takes to create the page,

andy75180

Okay, 'mysqli_connect' sounds like what I need. I will design my system around this.

One more thing, should I just have the 1 login and password to access mysql or create a separate ones for each of my members using the 'CREATE USER' function with the same privileges?

HalfaBee

You should only need one mysql user, you need to seperate website users from mysql users.

andy75180

Okay, thankyou everyone for your kind replies. I will design the system around your suggestions.