Databases
StackOverflow2013
Postsdbo
POjqgrid load large data set without pagination
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POjqgrid load large data set without pagination
    primarykey
    data
    text
    <p>I was wondering whether there is a better way to load large Json data set from the server.</p> <p>I am using jqgrid as loadonce:true. i need to load around 1500 records at once and also i don't use pagination options. is there any better way to achieve this? Thank you in advance.</p> <p>This is my Grid code - </p> <pre><code> $(function(){ $("#testgrid").jqGrid({ url:getGridUrl, datatype: 'json', mtype: 'GET', height: 250, colNames:['Inv No','Date', 'Client', 'Amount','Tax','Total','Notes'], colModel:[ {name:'id',index:'id', width:60, sorttype:"int",search:false}, {name:'invdate',index:'invdate', width:90, sorttype:"date",search:false}, {name:'name',index:'name', width:100,search:false}, {name:'amount',index:'amount', width:80, align:"right",sorttype:"float"}, {name:'tax',index:'tax', width:80, align:"right",sorttype:"float",search:false}, {name:'total',index:'total', width:80,align:"right",sorttype:"float",search:false}, {name:'note',index:'note', width:150, sortable:false,search:false} ], multiselect: true, multiboxonly:true, caption: "Manipulating Array Data", pager: '#testgridpager', //Auto load while scrolling //scroll: true, //to hide pager buttons pgbuttons:false, recordtext:'', pgtext:'', loadonce: true, sortname: 'id', sortorder: 'asc', viewrecords: true, multiselect: true, jsonReader : { root: "rows", //page: "page", //total: "total", records: "records", repeatitems: false, cell: "cell", id: "id" }, loadComplete: function(data) { var rowId; //alert(data.length); //alert('load complete'+data.rows.length); //set checkboxes false if mode is set to true if(mode){ for(var i=0;i&lt;data.rows.length;i++){ rowId=data.rows[i].id; disableRow(rowId); var searchVal = $("#gs_amount").val().trim(); if(searchVal ==data.rows[i].amount){ jQuery("#testgrid").jqGrid('setSelection',rowId); //heighlightSearch(); } } } } }); //toolbar search $("#testgrid").jqGrid('filterToolbar',{stringResult:true,searchOnEnter:false}); }); function disableRow(rowId){ $("#testgrid").jqGrid('setRowData', rowId, false, {color:'gray'}); var trElement = jQuery("#"+ rowId,$('#testgrid')); trElement.removeClass("ui-state-hover"); trElement.addClass('ui-state-disabled'); trElement.attr("disabled",true); } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USSam
    1. USSam
    plurals
    1. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POjqgrid load large data set without pagination
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POjqgrid load large data set without pagination
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POjqgrid load large data set without pagination
      1. USAlok Swain
      1. VTFavorite
    1. COCould you include the javascript code which you currently use? Do you use local paging of the data? Do you use `gridview:true` parameter?
      singulars
      1. POjqgrid load large data set without pagination
      1. USOleg
    2. CO@Oleg - Thanks oleg. i used gridView parameter. please find the updated question.
      singulars
      1. POjqgrid load large data set without pagination
      1. USSam
    3. CO@Sam: I am very busy now, but if your problem will not be solved till Saturday I'll write you some suggestions. What do `disableRow`? I am not sure that I understand what you do inside of `loadComplete`. If in the filter bar for `amount` no data exist you should do nothing. If in `amount` the data exist the data are filtered and you should select all rows. Is it so? Moreover I don't see `gridview:true` parameter. Is the example which you posted the real example which you tested? How long time is the loading in your tests? Which browser is the most important for you?
      singulars
      1. POjqgrid load large data set without pagination
      1. USOleg
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload