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


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)

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)

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)

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)

A proposal has not yet been provided

$35 CAD in 3 days
(60 Reviews)

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

$247 CAD in 8 days
(7 Reviews)

Hi i also have my phpfox community you can check this at 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)

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)

A proposal has not yet been provided

$315 CAD in 3 days
(0 Reviews)