Closed

Optimising Socialengine based site and database

PROBLEM:

Our website is based on Socialengine CMS (Zend framework). It is very slow. This is because:

1) The database (Server version: 5.5.5 MariaDB) is large at 25GB and requires optimisation. Even when we remove all the active content (widgets, text and images) from our member page it still takes a while to load, suggesting database is very heavy and slow. We know tables are too big and need to be broken out for example.

2) There is also a lot of old code and plugins we dont use. There is a lot of code on pages which is not needed.

3) GT Metrix and google page speed score makes a number of sugestions that can help, but the above 2 points are the main issues

SERVER BACKGROUND:

To recap, have a powerful dedicated server, it is 64GB ram, the storage is 1000GB NVMe hardrive. The CPU benchmark is 15,277. More details: [login to view URL]

We also use clourdflare.

We have a server team who have optimised the server, enabled cache etc...

[login to view URL]

[login to view URL]

SLOW QUERIES

The server team have enabled this so needs a coder to review and optimise.

OUR SITE LOAD AND PROBLEM PAGES:

We have 30,000 members, however, daily page views are usually just 1,000 to 2,000. Therefore we are not experiencing high traffic.

The club pages (which are our member pages and can be accessed without login) load very slow. In social engine each club is effectively a network).

Please load the following pages:

1) Homepage: [login to view URL]

[login to view URL]

As per above, the google page speed score for destkop on 25.01.19 is 65 out 100

[login to view URL]

As per above, the google page speed score for mobile on 25.01.19 is 29 out 100

[login to view URL]

As per above, the page speed score is 34% and yslow score 59%

2) Club page: [login to view URL]

[login to view URL]

As per above, the google page speed score for destkop on 25.01.19 is 32 out 100

[login to view URL]

As per above, the google page speed score for mobile on 25.01.19 is 7 out 100

[login to view URL]

As per above, the page speed score is 15% and yslow score 55%

Skills: Database Administration, HTML, MariaDB, MySQL, PHP

See more: want build twitter based site, example auction site database, create div based site, move site database, community site database, resume site database, site database grabber, magento based site, convert static web site database, point based site, aspdotnetstorefront based site india, creating site database, convert php site database, php based site, jobs site database, search engine joomla site database, html javascript based site database

About the Employer:
( 0 reviews ) Hampstead, United Kingdom

Project ID: #18624048

1 freelancer is bidding on average £94 for this job

ashutoshkumar28

Hi I will get this done as per your requirement. Please come over to chat we will discuss further. waiting to hear back from you Also the membership fee was charged to me and after that I got the notificati More

£94 GBP in 30 days
(7 Reviews)
3.8