Loading a large collections with livewire powergrid #1666
-
|
When using Eloquent Query and loading 1million records it works perfectly but when i use collections it takes forever to load. How can i optimize this without having any memory issues? |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment 1 reply
-
|
Hello! Using a collection with a database with so many records is not advisable. The performance problem will depend on how many columns you are displaying, and the database latency, and with 1 million records in the collection, it will overflow the memory. |
Beta Was this translation helpful? Give feedback.
-
|
Alright thanks |
Beta Was this translation helpful? Give feedback.
Hello!
Using a collection with a database with so many records is not advisable. The performance problem will depend on how many columns you are displaying, and the database latency, and with 1 million records in the collection, it will overflow the memory.