This website account was suspended due to using too much system resources through database queries. I reviewed and optimized the Mysql database by deleting hundreds of thousands of old records, adding indexes and optimizing tables. I reviewed the code and optimized queries to better address how the client was using the data. I then wrote a script run by crontab weekly to delete all new records over six months old to keep the database tables from growing too large.
projects, maintenance and bug fixes in PHP websites