The updatedSearch method in the Livewire Datatables component is fetching all records from the database when processing searches. This has the potential to cause significant performance problems, including database server timeouts and HTTP 504 errors, when handling large datasets.
Steps to Reproduce:
Use a datatable with a large number of records.
Utilize the search functionality.
Experience performance issues and potential timeouts or 504 errors.
Expected Behavior:
The search functionality should efficiently filter results without retrieving all records from the database, avoiding timeouts and ensuring a smooth user experience.
Actual Behavior:
The method updatedSearch currently retrieves all records, causing inefficiencies and server errors.
Possible Solution:
The updatedSearch method could be improved by using a paginated or scoped query to fetch only the necessary records.
The updatedSearch method in the Livewire Datatables component is fetching all records from the database when processing searches. This has the potential to cause significant performance problems, including database server timeouts and HTTP 504 errors, when handling large datasets.
Steps to Reproduce:
Use a datatable with a large number of records.
Utilize the search functionality.
Experience performance issues and potential timeouts or 504 errors.
Expected Behavior:
The search functionality should efficiently filter results without retrieving all records from the database, avoiding timeouts and ensuring a smooth user experience.
Actual Behavior:
The method updatedSearch currently retrieves all records, causing inefficiencies and server errors.
Possible Solution:
The updatedSearch method could be improved by using a paginated or scoped query to fetch only the necessary records.