I have a PHP login class set up with the Singleton design pattern. I'm wondering if I have multiple users logging and updating using this class will I encounter any problems with number of connections (since it's a Singleton design pattern).
Should I create a PHP login system with a Registry Pattern instead. I noticed that one limitation I had with the Singleton design pattern is that I set the database in it and so for a user to use another database then I had to create another instance of the connection.
I'm wondering if using mysqli is more efficient than PDO. I coded it with PDO. Mysqli has the function to end the connection. I don't know how PDO handles it though. Right now I don't have a lot of users but I want to be able use my login code that will scale well.
I guess in a related way the number of MySQL connections is set in my.conf but I'm not certain. Any suggestions? How would I test that my class can handle x number of users of logins?