Hello, i have an php video script(custom written) on my web site,including legal adult [url removed, login to view] has heavy loading issue. When online users excess number of 1k, apache server giving internal server 500 [url removed, login to view] is a caching system on script but i m not able to check or develop it to work correctly.I think the main problem is too much database queries occurs at the same [url removed, login to view] is hosting on Hostgator's web hosting service.
When i ask my website hosting provider(which is hostgator) they said that process limit has been exceed(which is limited to 25 processes).Database queries takes too long so need to implement table indexing and query caching or something else to decrease process usage.
I need a php developer and mysql expert to solve this issue.I can give detail informations who want to work on thid project
7 freelancers are bidding on average $57 for this job
Hello sir I have done this task a couple of times in my past projects. I'm very much interested in doing this task for you. Thank you for giving your precious time to review my bid and check PM for more details!
I inform you that I optimized a database with more than 8 GB in the main table, the response time increased from 23 seconds to 2 seconds, thank you to contact me for more details.