Cancelled

PHP/MySQL Programmer

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

Skills: MySQL, PHP

See more: php mysql programmer, MYSQL programmer, alpha2, mysql sort, mysql php example, php mysql work order, php mysql count limit, php sort price, seo php mysql, php mysql seo, part time php mysql, php mysql order script, count mysql, php mysql hosting script, seo mysql script, hosting order php script, php mysql count, sort order php, seo company scripts, select mysql php, select count php, php order records, php limit time, order records mysql php, mysql sort order

About the Employer:
( 29 reviews ) United Kingdom

Project ID: #5485123

24 freelancers are bidding on average $19/hour for this job

kchg

Hello, sir I'm interested with your project. I have good skill and my place is 8th in freelancer. I'll do it for you. I can do it well more than you could guess. :) If you give me this project, i will work More

$25 USD / hour
(381 Reviews)
9.4
otssols

Hi,___Thanks for your post.___We will be interested to help you with your requirement. We are quite good and effective with designing and developing websites and have considerable experience.___ Your hosting company fa More

$15 USD / hour
(35 Reviews)
7.9
phpdeveloper100

Hi We are very interested in this [url removed, login to view] can do that job in a normal [url removed, login to view] have great experience of [url removed, login to view] have experience of preparing Complete Scope,Complete documentation,attractive design ,Webdevelopment,Q More

$19 USD / hour
(71 Reviews)
7.2
geomago

I would like to have a glance to your problem. If you can grant a read-only access to the DB (or to a test-version of it) and give me a copy of the script (or access to the script source) I can verify the nature of the More

$20 USD / hour
(46 Reviews)
6.5
foreignt

Hello, My name is Vladimir Shekhovtsov, CTO at Zeus Electronics. We are Ukrainian outsourcing company with 5 years experience in web and mobile applications development. Our portfolio consists of more than 70+ web r More

$22 USD / hour
(21 Reviews)
6.5
qactivoinfo

Hi! we are PHP & MySQL Expert and we can do it! if you are interested, please contact us! You will not regret! Thanks you very much! Greetings!

$24 USD / hour
(16 Reviews)
6.2
developer2581

HI Hello Sir, We have gone through the details you have provided and would be pleased to work on this with you to deliver the results that you have expected and We are sure you will not be disappointed if you give us More

$16 USD / hour
(29 Reviews)
6.5
ebinarylogix

Greetings, Thank you for giving us a chance to bid on your project. We have looked at your project specs and we are confident that we can deliver you robust and reliable solution. We have successfully completed more th More

$20 USD / hour
(27 Reviews)
6.3
loufyla

Hello, I'm interested by your project since I have been working with PHP and MySQL for more than 8 years now and so I think I'll be able to help you with your problem. From what I can see, the requests that are done More

$16 USD / hour
(36 Reviews)
5.5
flashmadphp

Hi sir i can fix them and replace with refined code which will assure website performance(improve loading speed and won't kill hosting) I would like to see the site front end so i can make suggestions or give you More

$16 USD / hour
(154 Reviews)
5.4
bdsitech

Hi, I have completed 100+ projects with PHP & MySQL.I have long time experience to work on website and its development using PHP/[url removed, login to view] can check my profile and feedback records. If you award me this project it wil More

$33 USD / hour
(48 Reviews)
5.2
zikaa

Hello, I am PHP/MySQL programmer and can take a look at your script. From what you wrote, it is not related to any SEO, those are product queries, probably for some shop (SEO usually does not need MIN prices or More

$22 USD / hour
(10 Reviews)
4.9
quocthinh

Hi Currently, I'm is project manage in the software development team, the group built its specialized small and big websites have good quality and skills of their team plays the following documents: That websi More

$22 USD / hour
(10 Reviews)
4.3
annaijobs

Hi, I take this opportunity to introduce myself. My name is Jeni and I am the BusinessDevelopment Executive of annaijobs. Understanding: 1. To provide php/mysql programmer. Mockup could be provide before a More

$15 USD / hour
(16 Reviews)
5.3
cybert2t

Greetings Sr, About me. Resume: Over 9 years of involvement in computer software development, successfully working with individuals and group engagements through the Software Development Life Cycle, software des More

$15 USD / hour
(10 Reviews)
4.4
dzsysop

Hi, Sounds very simple. Just need cpanel and/or ftp access to your website to see php and mysql Are you sure that problem is only in those queries? Is it acceptable to use any caching tricks? How much traff More

$15 USD / hour
(8 Reviews)
3.2
udaypatelmca

Hey, I am senior PHP/mysql developer + ORACLE certified sql/plsql developer. i can optimize your sql queries to reduce db cost. this job best fit to my skills.

$15 USD / hour
(6 Reviews)
2.4
jayanbee

In your query example, subquery is used. So it may be creating a temporary table for executing the query and overload the server. Your table structure is need to be looked for analyzing whether mysql joins can be inste More

$15 USD / hour
(3 Reviews)
1.5
ppandare

We are '3stechmind' team of dedicated software professionals developing the web projects for our [url removed, login to view] area of expertise is design the web site and implement the functional aspects in software technolgies like ph More

$20 USD / hour
(3 Reviews)
1.6
bedriguler

Hello, No need to pay for this. You should just change the queries such that: SELECT count(1) AS cnt, MIN(price) as minPrice, MAX(price) as maxPrice FROM ( SELECT * FROM cddata WHERE dvlatype='NEW' AND alpha1='MS' More

$20 USD / hour
(0 Reviews)
0.0