[eluser]Unknown[/eluser]
hi
I developed a website using code igniter, mysql and hosted it in hostgator.com and now the server guys are having the problem with it
problem:
The database was found to be consuming an inordinate amount of processor time, to the point of degrading overall system performance
--- hostgator.com
here is the details
1)i have autoloaded the database class
2)$db['default']['pconnect'] = TRUE;
3)website does some heavy lifting both php/database
possible solution
manually load the database class and free the resources, i tried it
after adding $this->load->database();(not to the constructor of the model but in a method) i tried $this->db->close(); which means that my connection is broken and i cannot communicate with the database, but its not the case here. I can still fetch the data from the database from another model(without $this->load->database()) which means the connection is still alive
is there any way i can close this connection and reopen as and when required
Thanks in advance
