Fetch One Million Record

Pagination. I doubt you have enough ram, etc, to load 1M records. Usually you paginate through that many.

Why do you need to fetch 1M at once?

its users record, so i need to view all users, what techniques do you suggest

What I said...pagination. Have you ever been to a single site that lists 1M records without pagination? I doubt it!

Usually you get like maybe 25 records at a time. Page 1 has 1-25, page 2 has 26-50, etc.

Laravel makes this pretty easy. https://laravel.com/docs/5.6/pagination

Thanks, i guess have seen the problem, i paginated and was slow, i actually had an issue with the model. have optimised it.

Make sure your tables are properly indexed. Fields that you sort on should be. I have a lot more records than you, and it takes about 400ms to retrieve a page using multiple relationships.

If your question is answered, please mark the thread as solved.

Here is a very good video tutorial on proper indexing. I'd highly recommend watching it. He shows before/after indexing speeds on a lot of records. https://serversforhackers.com/laravel-perf/mysql-indexing-one

No one views 1 million records. Do a search and just get the records needed to view.

1 million records, seriously.

that'd be like doing a Google for everything Google has rather than say searching for dog salons.

I have never heard anything like this.

thats likely to increase to 3 million in few weeks

Even if you viewed a record per second you would have to sit there for 34 days to view all that.

You really need to take a few weeks and learn some database techniques before delving deep into laravel.