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 Link to comment https://forums.phpfreaks.com/topic/34474-persistant-mysql-connectioni/ 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. Link to comment https://forums.phpfreaks.com/topic/34474-persistant-mysql-connectioni/#findComment-162520 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? Link to comment https://forums.phpfreaks.com/topic/34474-persistant-mysql-connectioni/#findComment-162567 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. Link to comment https://forums.phpfreaks.com/topic/34474-persistant-mysql-connectioni/#findComment-162602 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.