Datatable carga 100.000 registros en una sola página
Datatable carga 100.000 registros en una sola página
Estoy cargando una tabla de MySQL con 100.000 registros en un datatable, utilizo serverSide y ajax para traer los datos de la tabla.
También tengo otros scripts para el lenguaje en español, los botones de excel, PDF, etc.
El script carga bien los datos (muy rápido) pero al pintarlos en la tabla los coloca todos en una sola página, es decir, coloca bien todo el formato que le doy a la tabla con su paginación pero todos los registros los coloca en una sola página.
He buscado en los foros pero no consigo nada que me ayude.
This question has an accepted answers - jump to answer
Answers
Translated with DeepL.com (free version)
Sounds like something is wrong with your code :-) So please post an example or at least your code as per the forum rules. Thanks.
Have you considered using Editor? Great solution at a very low license price. I think I pay less than $50 annually. https://editor.datatables.net/purchase/index?currency=usd
Here is my code for a simple data table that is fully editable and lightning fast. It has 140,000 records currently. I guess my "patience" remarks (see below) are no longer needed
I see you're using Editor in your example, but our accounts aren't showing that you have a license - it just reports that your trial expired several years ago. Is the license registered to another email address? Please can let us know so we can update our records and provide support.
Colin
I never had a trial, Colin. I purchased the license right away and for some time I have used your subscription. JoseAlberto doesn't seem to be using Editor at all.
Ah sorry all, I meant the license for JoseAlberto, but yep, that OP doesn't reference Editor.
Colin