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 = < >
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
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.
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
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