Find Jobs
Hire Freelancers

Optimising Socialengine based site and database

£20-250 GBP

Closed
Posted about 5 years ago

£20-250 GBP

Paid on delivery
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%
Project ID: 18624048

About the project

1 proposal
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
1 freelancer is bidding on average £94 GBP for this job
User Avatar
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 notification, what about that amount??? Hi, I got notification that I need to close the account. Just wanted to ask what about the amount which is in the account. Also the membership fee was charged to me and after that I got the notification, what about that amount Thanks in advance. Regards Anshikha
£94 GBP in 30 days
4.8 (7 reviews)
3.8
3.8

About the client

Flag of UNITED KINGDOM
Hampstead, United Kingdom
0.0
0
Member since Jan 30, 2019

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.