Posts

Showing posts with the label optimization

MySQL LIMIT Optimization

I have this scenario where MySQL LIMIT syntax is very slow for table having 30 million records. Solution Instead of using MySQL LIMIT you may use WHERE and BETWEEN which works pretty fast.