Optimize Mysql query for pagination around 5mil records
Budget: $30 – $250 USD
I need to reduce to the below 1sec currently take around few second do load the pagination
- index has been set
- count() caused slow
- order by caused slow
If you know anyway to optimize it further or any tools can help. please place the bid.
thank you
- index has been set
- count() caused slow
- order by caused slow
If you know anyway to optimize it further or any tools can help. please place the bid.
thank you