jaymc Posted January 16, 2007 Share Posted January 16, 2007 I have a chatroom and in the config there is an option to use a persistant MYSQL connectionIm assuming it has good points and bad points depending on the usageIm just wondering would it be a good idea to use it for a seriously busy chatroom (50 - 100 chatters)And if someone could provide some info about itCheers Quote Link to comment Share on other sites More sharing options...
hvle Posted January 17, 2007 Share Posted January 17, 2007 For a busy application such as chatroom, it is definitely a great benefit to use persistant connection. Think about how much time you saved on establishing and authentication connection to db server. Quote Link to comment Share on other sites More sharing options...
jaymc Posted January 17, 2007 Author Share Posted January 17, 2007 But wont it draine it in other ways? Quote Link to comment Share on other sites More sharing options...
hvle Posted January 17, 2007 Share Posted January 17, 2007 The moment you made a pconnect to your mysql server, the connection link stored in the php resource.the next time you query, without specify a link, php will look for a link inside the php resource.In case a you called pconnect again, php will check if there is a link in the resource. If there is, php simply execute the next statement. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.