已完成

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 [login to view URL] 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 [login to view URL]‘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.

技能: 互联网信息服务, MySQL, PHP, SQL, WordPress

查看更多: 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

关于此雇主:
( 2个评论 ) London, United Kingdom

项目ID: #4726929

授予:

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 更多

£1200 GBP 在7天内
(30条评论)
5.3

33 威客就此工作平均出价 £1267

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 在8天内
(140条评论)
9.0
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 在30天内
(503条评论)
8.5
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 在12天内
(199条评论)
8.7
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 在3天内
(1157条评论)
8.0
softservicesvw

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

£1500 GBP 在8天内
(338条评论)
7.7
buraqtech

Check your PMB for details!!!

£1221 GBP 在15天内
(106条评论)
8.1
qitsol

We are ready to do this.

£2061 GBP 在25天内
(107条评论)
7.6
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 更多

£1752 GBP 在10天内
(40条评论)
7.4
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 更多

£1394 GBP 在10天内
(154条评论)
7.6
ganeshbaid

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

£1500 GBP 在21天内
(151条评论)
7.2
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 在5天内
(254条评论)
7.0
kalpataru44

Hello Sir, We are highly interested to do your project.

£1030 GBP 在8天内
(47条评论)
6.3
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 在9天内
(125条评论)
6.5
vladang

Hello sir. I am interested for your job. Lets discuss Regards vladang

£1250 GBP 在3天内
(104条评论)
6.0
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 更多

£1082 GBP 在7天内
(45条评论)
6.8
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 更多

£1500 GBP 在3天内
(55条评论)
5.7
wilyjose

We are experts in Web Development

£1472 GBP 在3天内
(58条评论)
5.8
GNATECHNOLOGIES

Dear Sir, We offer most competitive rates with best quality. We are an experienced team of website development and SEO experts working in this field since last many years. Please check private message. Thanks and Regar 更多

£783 GBP 在30天内
(27条评论)
5.6
on2it

Hi, We can give you the best and quick output. We have a professional team in your required area, they work sincerely. You will get your desired output from us. We are very much concerned about quality and customer sa 更多

£1546 GBP 在30天内
(6条评论)
5.2
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 更多

£1263 GBP 在25天内
(9条评论)
5.0