We have a LAMP Cloud App in PHP 7 using MySQL. We use nested queries and it takes a long time to get to the desired records.
Among the options we are looking at to speed up the queries are:
Change to another Database (Please advise which)
Optimize the code
I'll appreciate letting me know what to do to speed up the queries.