I have a PHP/MySQL script that creates website hit counters. The script generates some code which is placed on a website. Each code has a counter ID. The counter counts and displays the number of visitors. The script uses a lot of RAM and CPU power. I need to reduce it as much as possible and modify the admin section. Here is what I need:

MODIFICATIONS
1. Make the script more efficient to reduce CPU usage (load) and reduce the RAM usage.
2. Make additions or modifications to the admin reporting as follows:
a. Search counter by ID efficiently
b. Delete counter by ID
c. Remove some reporting functions entirely.

Note:
1. See PMB for site details
2. Currently there is no search by ID and searching by other parameters is very slow and times out.
3. Some of the reporting is useless and needs to be removed. The reporting itself may be slowing down the script.