Closed

PHP/MySQL Programmer

This project received 28 bids from talented freelancers with an average bid price of $20 USD / hour.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$15 - $25 USD / hour
Total Bids
28
Project Description

My hosting company are complaining that some scripts on my site are killing their servers. A SEO company that was doing some work for changed some of the scripts. Essentially the script is counting over 40 million records all the time, I believe that this may have been done as part of a sort of results records.

Example of the script :

SELECT count(*) AS cnt, MIN(price) as minPrice, MAX(price) as maxPrice FROM ( SELECT * FROM cddata WHERE dvlatype='NEW' AND alpha1 = 'MS' AND alpha2 LIKE 'M_S' ORDER BY numeric1 ) a LIMIT 0, 500

SELECT count(*) AS cnt, MIN(price) as minPrice, MAX(price) as maxPrice FROM ( SELECT * FROM cddata WHERE dvlatype='NEW' AND alpha1 = 'MS' AND alpha2 LIKE 'M_S' ORDER BY numeric1 ) a LIMIT 0, 500

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online