进行中

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.

技能: 互联网信息服务, 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

About the Employer:
( 2 reviews ) 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天内
(28条评论)
4.9

34名威客为此工作的平均竞标价是£1264

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天内
(84条评论)
8.3
buraqtech

Check your PMB for details!!!

£1221 GBP 在15天内
(75条评论)
7.7
softservicesvw

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

£1500 GBP 在8天内
(328条评论)
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 在12天内
(89条评论)
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 在3天内
(620条评论)
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 更多

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

£1394 GBP 在10天内
(112条评论)
7.2
alinawaz88

gazelle Lets do it

£1473 GBP 在10天内
(112条评论)
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 在30天内
(155条评论)
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 在25天内
(16条评论)
6.8
ganeshbaid

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

£1500 GBP 在21天内
(139条评论)
6.8
qitsol

We are ready to do this.

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

£1082 GBP 在7天内
(45条评论)
6.8
basbas112

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

£1500 GBP 在8天内
(34条评论)
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 在9天内
(46条评论)
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 在5天内
(70条评论)
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 更多

£995 GBP 在20天内
(14条评论)
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 在7天内
(27条评论)
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 更多

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

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