Loading only fixed number of entries on page load

adityag28

Hii, if I have around 1000 entries and I decide to show 100 entries per page.
When I will open the webpage, will it load all the 1000 entries in the starting or will load only 100 entries and then when I will go onto the next page, then it will load the other?

kthorngren

If you are using client side processing then the full table data resides in the client. If you use server side processing then only the page being displayed resides at the client. See the Processing modes docs for more details. Client side processing is more flexible and easier. 1000 should work fine with client side processing.

Kevin

colin

It depends where the data is. If it's in the DOM, then by default it will load everything. If you're making an ajax call to get the data, again, by default it gets everything, but you can use serverSide to limit that. This section of the FAQ should help, it discusses various techniques to improve performance,

Cheers,

Colin

adityag28

Will having no more than 4000 entries not effect on the speed of the webpage?
Means- If I load the full table which has a max of 400 entries, will speed of the webpage be affected?

kthorngren

The numbers posted in the FAQ are general guidance. The performance is affected by how long it takes to fetch the 4000 rows, the number of columns, how much custom rendering is taking place, etc. It is something you will need to test with your specific solution.

Kevin

colin

If you've only got 400 records, just keep it simple and work in the client - that's minimal and DataTables wouldn't even break a sweat.

Colin

adityag28

I have got around 3000 records, how do I first load only the records on the first page, to decrease the loading time?

kthorngren

Server side processing is the Datatable supported way of paging the server data. It requires a server script (Datatables provides some examples) that supports the SSP protocol.

Or you can create your own paging mechanism and use ajax.data as a function to send information about what page of data to load. This willl be client side processing so you will likely want to use paging to disable paging. Sorting searching will also take place with the client side data.

Kevin

adityag28

What should be my data-source in this?

kthorngren

What should be my data-source in this?

The URL to your server script.

Kevin

adityag28

I mean I am using Django as my backend and I am uploading the data from the admin panel. I am not using json file for this.

kthorngren

Not sure what the Admin Panel is. Datatables supports DOM sourced tables or tables loaded through Javascript or Ajax. See the Data docs for more details. To use Server Sid eProcessing you need to use the ajax option. There are third party Django libraries to support server side processing, like this:
https://pypi.org/project/django-serverside-datatable/

I haven't used any of them so not sure how well they work

Kevin

adityag28

Thanks, I will try that.