I have tried with following technique still not able to speed up.
- N+1 query problem. : Batch_loading or eager_load concept
- Pagination.
- caching.
- DB indexing
- Data loader
- Batch query
These all technique i have used still not able to do, please give me any suggestion how can i achive this ?