My website has a big database of advertisements where there are approximately 500,000 ads. My website's SQL query is not being able to handle this huge database and few SQL queries are being executed very slowly.
The website is hosted in a very good dedicated VPS, so hosting server is fine for the huge database but the website's SQL query need to be modified so that it can load and perform faster.
My VPS >> "MySQL Slow Query" log showing few specific queries are taking too long and those queries are affecting other queries to be executed slowly!!
I need you to fix this SQL query issue. my guess is, current SQL queries are not using proper "INDEX" & "SELECT" queries without limit!
There are 3-6 queries i think (can be bit more, not sure!) which are loading slowly and making other queries load slowly and you will be fixing those in this project.
After completing this project, i will need you to work on another few projects for me, so your bid should be with a reasonable price because of ongoing job!
If you can't work on this project right away, please do not bid ! ! !
47 freelancere byder i gennemsnit $149 på dette job
Hello sir. Nice to meet you. As a sql expert, i can help you well. I have good experiences in big database query. I am ready for your project always. Please contact me for your job. Thank you. Regard
hello. i am interest in your project. i have enough skills and full experience for your project. if you give me chance, i will do my best for you. thank you.
Hi, I have 15+ years in sql development and query optimization in variety of databases such as MSSQL, MySQL and 5+ years specifically in MySQL database. hope to hear from you regards Babu