We are using a script that collects pings from a pixel put on a user website. Our script then collects this ping and ranks the website in terms of visitors.
This script worked perfectly until we recently optimized the mysql db.
Now the server is overloading. We once had this problem before and we do think it is due to the cache of the ping updating every second.
It should be a fast job to fix for a person experienced in php and mysql.
We would love to have it fixed before Sunday.