In Progress

Database Opimisations to speed up site

Background:

We are a UK-based market research and consulting agency. We have an existing, working website for our community of 150,000 young people before, during and after their time at university.

Our website at [url removed, login to view] is built in WordPress, with many customisations of our own, and runs on our own, collocated Windows Web Server 2008.

The main database for WordPress and associated functionality sits on the web server itself. The website links to an external providers SQL database where our community data is stored by a software provider. We use custom functions for read and write access to said database to facilitate community members logging into our website, checking incentives etc.

The Task:

We are happy with how the site looks and functions, but current load times are unacceptably slow.

This is largely due to calls to the internal SQL databases, which account for about 15-16 seconds(!) of the overall 18 seconds load time.

The task is to reduce the overall page load time to under 4 seconds (as measured by [url removed, login to view]‘s speed test) by heavily optimising database calls and database caching.

WordPress caching can also be explored, but so far it has been a struggle to find a WP caching option that works with our user login process. We are however open to any sensible combined approach of DB caching and WP caching.

Please quote the word “gazelle” in your response to be considered.

The project will only be considered to be successfully completed if the page load times drop below 4 seconds, without affecting any of the site’s user-facing functionality. There will be no partial success/partial payment arrangement. Payment will be in full upon the successful completion of the project within the agreed time frame.

Required Skills:

A solid understanding of generic web technologies and specifically WordPress in an IIS (not Apache!) environment.

Well-versed in IIS and Windows Server admin interfaces.

Expert-level skills in MySQL and MS SQL, especially in the fields of speed optimisation and caching.

Framework:

The deployed technology (IIS, WordPress, PHP and extensions/customisations) needs to be unchanged.

All SQL queries need to be sanitised.

Timeline:

Please supply your proposal by close of business on Tuesday, July 16th.

We will pick a suitable freelancer by close of business on Wednesday, July 17th.

This project is fairly urgent; the work needs to be completed by close of business on Wednesday, July 24th.

This includes testing, amends and sign-off by YouthSight.

Skills: IIS, MySQL, PHP, SQL, WordPress

See more: young's market, young freelancer com, www it freelancer co uk, www freelancer in uk co uk, www freelancer co uk php site, www freelancer com logging, www freelancer com co uk, wordpress website for consulting, wordpress test for freelancer, wordpress freelancer uk, which freelancer site, where to sign in as freelancer, where to find work as a freelancer, where to find software testing, where to find freelancer work, where to find a freelancer, where find php freelancer, where can find freelancer to write project, user testing freelancer, user test freelancer, user research freelancer uk, up work freelancer sign up, uk wordpress freelancer, uk market research freelancer, uk freelancer community

About the Employer:
( 2 reviews ) London, United Kingdom

Project ID: #4726929

Awarded to:

krtsl

Hi, gazelles are awesome, also, I am a SQL expert and Zend Certified PHP5 Engineer well versed with IIS on Windows, and can have this ready and signed off by wednesday week. Currently deployed technology will not be ch More

£1200 GBP in 7 days
(28 Reviews)
4.9

34 freelancers are bidding on average £1264 for this job

omsoftware

Hello, We are professional developers with similar DB optimization expertise and assure you best quality work. Please view PMB for details. Thanks

£1195 GBP in 8 days
(84 Reviews)
8.3
buraqtech

Check your PMB for details!!!

£1221 GBP in 15 days
(75 Reviews)
7.7
softservicesvw

Greetings gazelle, We would like to avail required solution. Please check PM.

£1500 GBP in 8 days
(328 Reviews)
7.6
madhavdutta

Hi I will optimize the speed of your website. I have 8 years of experience in WordPress Design and development. Please check my latest work.

£1030 GBP in 12 days
(89 Reviews)
7.5
sureshdevi

I can optimize your opinionpanel website in wordpress / IIS and reduce less than 4 seconds. I will complete this work in 3 days.

£752 GBP in 3 days
(620 Reviews)
7.4
USAGraphicPR0

**********************.. YOUR SEARCH ENDS HERE .. ********************** GET IT DONE RIGHT THE FIRST TIME! Hello Sir/Ma'am, I look forward to talking to you further and getting started. I've been working in simple and More

£1752 GBP in 10 days
(36 Reviews)
7.2
itcslive

Dear sir, we are a web design, web development expert company. We are offering an efficient,professional ,friendly service. Can you check our skills in Private message box and discuss with us about your project? Thanks More

£1394 GBP in 10 days
(112 Reviews)
7.2
alinawaz88

gazelle Lets do it

£1473 GBP in 10 days
(112 Reviews)
6.9
hikaruvn

---------------- I am very interested in doing this job within your Defined Budget,ready start project right now ------------------- Please check PMB for more Details thanks

£1200 GBP in 30 days
(155 Reviews)
6.9
onelinewebdeUK

Thanks for your consideration, please see our message and if you would like to discuss the project further do get in touch and I’ll give you a call.

£1546 GBP in 25 days
(16 Reviews)
6.8
ganeshbaid

Time bounded Delivery. Fast and Quick Response. Quality Assured. Let’s do it. Check PMB for more details.

£1500 GBP in 21 days
(139 Reviews)
6.8
qitsol

We are ready to do this.

£2061 GBP in 25 days
(101 Reviews)
6.7
amritb

“gazelle” - We have thoroughly checked your requirements and your specifications are clear and succinct. With our years of experience and expertise, we are confident to drop the page load times below 4 seconds, without More

£1082 GBP in 7 days
(45 Reviews)
6.8
basbas112

I can start and finish this for you please check your PMB

£1500 GBP in 8 days
(34 Reviews)
6.5
fastfivedesigner

****** We are Wordpress, php And MySQL platform Experts as our Reviews shows . My Expert Programmers will optimize your DB speed . Tom grey ( FastfiveDesigners ) *******

£1250 GBP in 9 days
(46 Reviews)
6.0
shsaad

gazelle - I am interested to take up this project. I have improved performance and load time for many wordpress websites before.I know what I am doing in wordpress.

£1250 GBP in 5 days
(70 Reviews)
5.9
bistanil98

have gone through with the requirement and we can start this project now. I want to introduce our self, we are a group of freelancers we have 11 year of experience in web application development and design, we w More

£995 GBP in 20 days
(14 Reviews)
5.8
tiabrains

Dear Sir, We are working in IT industry since last fifteen years and ready to help you in your project. Please check PM for more details. Best regards

£1340 GBP in 7 days
(27 Reviews)
5.9
itsoftwarelab

Our main focus is to deliver the quality work with full support to our clients at very competitive rates. We will be happy to work with you on long term basis. So please consider us for your project. Hoping for the More

£1500 GBP in 3 days
(28 Reviews)
5.1
alexwordpress

Hi, Thanks for posting this job in this platform. We have experts with us who can finish your job with in time frame and to the quality as per the requirements. For more information please check your Private Message More

£1263 GBP in 25 days
(9 Reviews)
5.1