In Progress

optimize SQL querys and php code

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

Skills: MySQL, PHP, SQL

See more: my sql databases, php code, optimize mysql, mysql to sql, optimize php code, php mysql sql example, sql optimize, rewrite sql, big databases, php mysql big data, php mysql optimize, php mysql query multiple, mysql tables rows, person optimize, php code example, rewrite data php mysql, code job board, optimize code, query optimize, mysql database php code, related php, optimize php mysql, php mysql rewrite, query optimize mysql, mysql query example

About the Employer:
( 45 reviews ) G?vle, Sweden

Project ID: #5023244

6 freelancers are bidding on average $51 for this job

maxtechsl

Hello, we are ready to optimize your Sql queries after going thro the php code. We assure you quality work. We already worked with you for your previous project. Regards, Evina.

$45 USD in 2 days
(64 Reviews)
6.2
phpraza

php mysql expert here with 2years of experience in web development. I am available now and ready to do this for you. lets do it

$155 USD in 1 day
(101 Reviews)
5.7
Kilr0y

Hey. I'm SQL expert, and I can make ur site faster. My price is 15$ per hour, and usually this job takes 3 hours = 45$. Ready to start right now. Regards, Alexander.

$45 USD in 1 day
(25 Reviews)
5.1
dimakrytovych

I can do this right now. But I need to look at your script to estimate amount of time and price that required.

$15 USD in 3 days
(0 Reviews)
0.0
mayurpatel3209

can get the jobe done within 3 hours. Have done a lot of mysql queries and also created views to enhance the query processing.

$20 USD in 1 day
(0 Reviews)
0.0
ketanniranjan

Dear We studied all your details. We expert in Database Administration. Please show our portfolio. We will develop query for your project as per your requirement in time. Thanks

$25 USD in 1 day
(0 Reviews)
0.0