Too many row load in server side process

urbanj

Dear Allan!
I not use paginate, and the server side load too many row when start ajax.
Can I decrease length parameter when called php?
in php:

   private function LoadData()
    {
....
        if(isset($_REQUEST["start"]) && isset($_REQUEST["length"]) && !isset($_REQUEST["action"]))
        {
            
            $len=$_REQUEST["length"];
....

I have 100 columns and i need read only 50 row each ajax call (50*100 field is 5000 field) , but I not can set loading row column number.

allan

I'm afraid I don't quite understand. If you can't use pagination, then there is no limit to the number of rows to be loaded - and the full data set will be retrieved automatically.

Allan

urbanj

Dear Allan!
In server side mode not load all data (5000 row). The serever side mode load blocks in first time, and load next block when I roll down, or previous block when I roll up, and send to php start, and length parameter in request (see my code).
I want to set this block size, but I not found this parameter.
I have now 400 rows and 80 columns, and the java send to server on firs time: strart 0, length 243, and if I roll down on ~140. row, tha java send: start 26 length 234, and I roll down on ~200. row, java send: start 82, and length 234 .......
I want to decrease length from 234 to 80 or maximum 100, but i not found parameter this settings.
This is my initializing settings:

dom: 'Bfrtip',
        "sDom": 'prtp',
        "ajax": {
            "url": ajaxId,
            "type": "POST"
        },
        info:false,
        buttons:true,
        serverSide: true,
        "bAutoWidth": false,
        scrollX:true,
        ordering: false,
        searching: false,
        processing:true,
        deferRender:true,
        scrollCollapse: true,
        scroller: true,
        stateSave: true,
        columns: tablefield,
        autowidth:false,
        

        keys: {
            columns: ':not(:first-child)',
            editor:  editor
        },
        select: {
            style:    'os',
            selector: 'td:first-child',

        },


        fixedColumns:   {
            leftColumns: 2},
        
        "columnDefs": [ {
            "targets": targets,
....

urbanj

Dear Allan!

I make test for You.
http://infoportal-hu.ddns.net:62080/index.php?module=TablePage&ID=25
If You need login, use these data:
email:allandatatables@gmail.com
Jelszó:
AllanDatatables

If you logged in jump again http://infoportal-hu.ddns.net:62080/index.php?module=TablePage&ID=25
You will see, the processing is too long.

allan

Thank you - I see the issue now. Could you try the nightly version of Scroller which I think will help with that start issue.

With the long processing, try disabling FixedColumns. Does that make it fast? You might need to reduce the number of rows being drawn as that is an expensive operation for FixedColumns to do.

Allan

urbanj

Dear Allan!
I want to set decrease scroller row number. The scroller new version have any parameter when I can change loading row number?

urbanj

Dear Allan!

I try the nightly version of Scroller, but is loading 243 row first time, and 234 any times, you not writo to me when parameter set maximum row number loading.
I disable fixed columns, and loading faster, but I need fixed columns because I have 80 columns, and my boss want see first 2 (3 if you ended bugfix fixed row editor) columns when He scroll to last columns

urbanj

Dear Allan!
Can You write to Me, what parameter is set the maximum row number in server side ajax call?

kthorngren

i think you want to use the scroller.displayBuffer option.

Kevin

urbanj

Kevin!

sroller.displayBuffer is working!
Thank You!