optimize SQL querys and php code
This project received 6 bids from talented freelancers with an average bid price of $51 USD.Get free quotes for a project like this
Project Budget$10 - $30 USD
Need someone to go through all my querys and related php code and finally rewrite to optimize the speed of showing data.
There is about 300 rows of querys and php code
at the moment in database there is about 120000 rows with multiple columns spread on multiple tables ( but when finnished with the database work it would hold about 100 millions rows spread on multiple tables )
So i need the person that takes the job to be really good of making big databases really fast in querys and show data.
example of sql query to rewrite:
$sqlexample = "select * from t1 where [url removed, login to view] IN (select exampleid from t2 where show='yes' )";
Just ask in clarafication board so all can see my answers on this job
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
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online