Awarded

PHPfox website Database Optimization

I'm experiencing a high load on my website due to a specific query driving my server crazy. I'm not very knowledgeable but I've talked to my hosting provider and they have showed me what the problem is. Here is what was told to me:

- Your feeds table is slowing down the server -- every page hit is triggering temporary table creation

which is slow and table-locking

- The feeds table has 36884 records in it. Due to the queries it's running on a very regular basis, this appears to be rather expensive

- The mysql server is stuck generating temporary tables (disk access which is very slow) for *every* page hit.

I don't know much about coding or databases and would need someone to help me with avoiding this problem. I've been given the exact query that is causing the problem so I can provide this to the person able to fix this problem.

Skills: MySQL, PHP, Web Hosting, Website Design

See more: website down for me fix, coding for website creation, website database, table creation, Query optimization, query creation, my website is so slow, fix mysql query, database optimization, need access database help, table optimization, php table locking, fix database access, php mysql load table, website hosting provider, optimization database, locking access, slow queries, website locking, mysql query slow, access query design, slow phpfox, phpfox mysql optimization, page load optimization, mysql slow queries

About the Employer:
( 3 reviews ) Maple Ridge, Canada

Project ID: #5373347

9 freelancers are bidding on average $238 for this job

coolguyinus2004

if you are online now here then i can start discussing with you the issues and fix it all for you today in few hrs time for the site. i have much exp in programming in PHP/MYSQL as you can check my reviews for it. let More

$188 CAD in 1 day
(313 Reviews)
7.5
ngscoder

Hi, Thanks for posting this project.With over ten years of experience Unisonlogix offer a creative web design, web development and graphic design service that draws on key marketing principles, to ensure you and your More

$226 CAD in 5 days
(136 Reviews)
7.1
igrowyourbiz

This is a common issue (among others) with scripts like phpfox. We can go in and stop this query from happening

$388 CAD in 3 days
(13 Reviews)
5.8
ataraxicsol

Hello. we can do the project according to your specification. we believe in quality work and on-time delivery. you can check our reviews. we have a dedicated team, so can start as soon as you award us the project. More

$368 CAD in 5 days
(20 Reviews)
5.8
NayaPakistan

A proposal has not yet been provided

$35 CAD in 3 days
(60 Reviews)
4.9
PavalSoft

We are sound knowledge in mobile apps, web programming, PHP, Open source, Css, HTML5, Animation, 3D modeling, graphic design, SEO and SMO.... www.pavalsoft.com

$247 CAD in 8 days
(7 Reviews)
3.5
proofisolution

Hi i also have my phpfox community you can check this at www.izdreams.com this a only a server problem tell me with server you are using check my website server speed

$222 CAD in 3 days
(2 Reviews)
0.0
smarttechnology1

Dear Hiring Manager, I’m a Web Developer, and I’m very interested in your job post “PHPfox website Database Optimization” I have recently worked for a US Company as a team leader, where my responsibilities includ More

$155 CAD in 3 days
(0 Reviews)
0.0
khanbaba11000

A proposal has not yet been provided

$315 CAD in 3 days
(0 Reviews)
0.0