We Require a strong pligg CMS coder to do the following:
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.
First and foremost, we need to optimize the tables.
Additionally, adding indexes to your table(s) may improve performance.
5-some optimization and the crawler blocking ( [url removed, login to view])
6-Create a simple, elegant and clean web design
based on the latest technologies CSS3 and HTML5
for faster loading and which will use less resources
7- -Provide more options for register/[url removed, login to view] should be
able to create an account using an existing account from sites
like Twitter, Facebook, Google, Yahoo, Aol, OpenID .