MedicOneSystems / MedicOneSystems/livewire-datatables
Select All on large datasets
Nobody has claimed this yet.
- Dominant language
- PHP
- Stars
- 1.2k
- Forks
- 257
- PR merge metrics
- No merged PRs in 30d
Description
I've created 40k records for a test run and the page itself times out. Chrome throws up a wait or kill the page when selecting everything. There are a few joins on the data, but nothing major and everything indexed. This might work on production servers with more horsepower, but I don't want to try that.
My solution would be to add another bool that if it's set to true, the select all would return the search + active filters. This way it can handle an enormous dataset and give the developers the exact means to recreate the select all and cut down on wasted memory/load times.
I'd be more than happy to devote some of our developers' time to get this as a feature if it's something you'd like in your code.
The only other viable option I can see is creating a plugin API much as the jQuery data tables does, obviously a lot different.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
The issue names no files or tests. Start by locating the select-all implementation and the query path that applies search and active filters, then reproduce the timeout with a large dataset. Done should provide a scalable way to select matching records without exhausting browser or server resources, with coverage for filtered selections.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- laravel, php
- Domain
- backend, performance
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 30/100