pligg programming

While diagnosing possible causes for a Pligg site running slower than I would like, We came along some SQL queries to perform some spring cleaning on a Pligg database. THe coder will be required to add some given code to SQL which will help remove stories flagged as spam.

2- Upgrade the site from CMS 1.1.1 to Pligg CMS 1.1.4

3- Install new template.

4- THe site has a very excessive MySQL activity which is is caused by

(a) a long-running process that locks a table, causing other queries to back up,

(b) a query that is not optimized ][example: select all from ... and involving a large or complex query],

(c) huge table copies/maintenance during peak hours.

NOTE:, the following are just possible fixes or suggestions we require your feedback.

Our aim is to reduce the amount of resources your SQL queries consume.