I am running my social network on phpfox v2 which is modified. I need somone who knows about phpfox and the database, I need it optimized. I am on a dedicated server and site runs slow.
Few things to note.
Site has modified Mass commenting feature for each member. This makes a lot of calls to the database.
this database grown big and when members use the feature, the site slows down.
You need to optimize the database so the site loads faster.
You need to be skilled with phpfox database.