Hi
I have a banner script showing 250,000+ banners a month. I was thinking it would be a good idea to start using mysql_pconnect() now I have php running as a module.
But when I look at the active mysql processes I seem to be getting several for this user (as used in the banner script). It seems to level off around 7. I notice that the time of some of the processes seems to drop backdown to 0 when the script is called again - does this mean that this connection is being reused? Why do I have so many - why not just 1 seeing as they all the the same user and from localhost? Do I need to change some configurations?
Thanks in advance
Will
I have a banner script showing 250,000+ banners a month. I was thinking it would be a good idea to start using mysql_pconnect() now I have php running as a module.
But when I look at the active mysql processes I seem to be getting several for this user (as used in the banner script). It seems to level off around 7. I notice that the time of some of the processes seems to drop backdown to 0 when the script is called again - does this mean that this connection is being reused? Why do I have so many - why not just 1 seeing as they all the the same user and from localhost? Do I need to change some configurations?
Thanks in advance
Will