I have small question for big perl job. I am using Asterisk IPPBX. I have my Perl script which is connecting to MySQL to Insert CallLogs etc.. All is working fine.
I have more than 500 active calls, it means my perl script calling each time when the call is finished with new MySQL Connection.
I wanted to get some logic to make only one connection to MySQL for each 500 calls. so for this connection i can avoid to make load for my Database server. Because i can see lot of problem some time DB is not responding some time table is crashing...
So please help me what can be login to make one DB connection for my script?