Find Jobs
Hire Freelancers

wikioo.org - Optimize SQL queries and PHP for speed

$30-250 USD

Færdiggjort
Slået op næsten 8 år siden

$30-250 USD

Betales ved levering
This is for expert only we would like to optimize [login to view URL] for speed by checking all SQL queries and optimizing SQL and PHP There is few issues with speed, but it is necessary to review and check every query, and every tables There is one or two day of work maximum for a real expert. Server is running LINUX and PHP ÄPACHE and have also WEBMIN PHPMYADMIN FTP task : - create all indexes (all columns used in any WHERE) - Review data type in all columns and in PHP (to match and avoid conversions) : --- to use INT only for the painting date and for artist date and for artist ranking and for painting ranking --- VARCHAR for everything --- TEXT for : painting description , artist biography , painting title , url please check everything and give recommendations Try to Remove all LIKE '%hello%'; in the WHERE Try to remove : NOT LIKE, NOT IN, NOT EXIST Try to Remove : WHERE substr ( COLUMN, 1, 1 ) = 'value'. All WHERE must be simple = < >
Projekt-ID: 10212307

Om projektet

12 forslag
Projekt på afstand
Aktiv 8 år siden

Leder du efter muligheder for at tjene penge?

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme
Bliv betalt for dit arbejde
Oprids dit forslag
Det er gratis at skrive sig op og byde på jobs
Tildel til:
Brug Avatar.
Hi! I'm expert in web development using PHP, and I'm experienced in high-load projects. Your project requirements are clear and could be implemented within one full working day (please note, it would take me several days, because I'm available only part-time).
$45 USD på 7 dage
4,9 (31 anmeldelser)
4,6
4,6
12 freelancere byder i gennemsnit $153 USD på dette job
Brug Avatar.
Hello. I have many years of experience in website/database optimization. Looking forward to being considered for the job. Thanks!
$200 USD på 4 dage
4,9 (361 anmeldelser)
6,9
6,9
Brug Avatar.
The database part should be easy, but depending on the size of your application...It may take a bit more than 2 days to go through it and run some benchmarks.
$250 USD på 3 dage
5,0 (50 anmeldelser)
5,7
5,7
Brug Avatar.
Dear Sir, Hope you are doing well, I have read your job description, I am willing to work with you. I have already done similar job and win 5 star rating with wonderful review. - I ll complete all of your requirements - I ll do more tweaks for you as well Sir i ensure you that i am best suit for this post. Please open chat with me so we can discuss more in details Looking forward to hear from you. Best Regards
$111 USD på 3 dage
4,9 (17 anmeldelser)
4,2
4,2
Brug Avatar.
A proposal has not yet been provided
$100 USD på 3 dage
3,2 (6 anmeldelser)
3,4
3,4
Brug Avatar.
Hi, We have more than 10 years of experience in IT industry. I can do this job very easily and within short period of time. Also our price is very reasonable. Please let me know if you want to work with us. Thanks & Regards, Pritam
$155 USD på 1 dag
4,4 (2 anmeldelser)
0,9
0,9

Om klienten

Flag for UKRAINE
--, Ukraine
4,9
144
Betalingsmetode verificeret
Medlem siden sep. 5, 2004

Klientverificering

Tak! Vi har sendt dig en e-mail med et link, så du kan modtage din kredit.
Noget gik galt, da vi forsøgte at sende din mail. Prøv venligst igen.
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.