c# - How to use JQuery "datatable" plugin server side processing with large data in .NET MVC3 razor views -

-

i have datatable displays list of employees. works fine when number of employees in 0-2000 range after there serious lag time when loading page. not surprizing since loading massive amount of data on page load. looked everywhere , couldnt find example shows how server side processing. projects found on git hub not working in computer(i got lot of "missing references" errors). code have working right now

the employees.cshtml

@model employeelist @{     layout = null;     viewbag.title = "employees"; } <html> <head>  <head/> <body>       <table id="employees_gridview">             <thead>                 <tr>                     <th                         name                     </th>                     <th>                         username                     </th>                     <th>                         job category                     </th>                     <th>                         hire date                     </th>                 </tr>             </thead>             <tbody>             @if (model.rowlist != null)             {                 foreach (var item in model.rowlist)                 {                   <tr>                     <td >                         @html.displayfor(i => item.displayname)                     </td>                     <td >                         @html.displayfor(i => item.username)                     </td>                     <td>                         @html.displayfor(i => item.jobcategoryname)                     </td>                      <td>                         @html.displayfor(i => item.hiredate)                                               </td>                  </tr>                 }             }             </tbody>             <tfoot>             </tfoot>         </table>     </div> </div>

the datatable jquery looks this

$(document).ready(function(){ $('#employees_gridview').datatable({             "bdestroy":true,             "bsortclasses": false,             "bdeferrender": true,               // here default setting number of results show on page             "idisplaylength": 10,             "bjqueryui": true,               "spaginationtype": "full_numbers",              "aasorting" :[],             // here column specific settings             "aocolumns": [             {"atargets": [ 0,1 ]},                          null,                          {"sclass": "datatablecentercolumn"},                             {"stype":"date", "sclass": "datatablecentercolumn"               }]         }); });

and controller method processes page load request

public actionresult index()     {         employeelist employeelist = getemployeelist();         return view("index", employeelist );     }

can please show me how can change client side datatable server side processing datatable.

i've used jquery datatables plugin code before, , if data (i.e., localhost), still slow -- spending lots of time in javascript/dom manipulation. make fast must virtualize jquery datatable. so, have modify both client & server code.

step 1) need have repeatable sql proc returns appropriate subset of rows. have 2000 rows total, need stored proc like

getemployedatarows(@startingrow) -- or pagenumber, or whatever convenient you.

make sure have stable query can "subsetted" appropriately. key step 1 want fast. row# or page# may not choice. if returnng rows in primary key orded, example, may smarter pass subset parameter @empnum , include employeenumber > @empnum in getemployedatarows

step 2) expose webservice (json based best browser consumption) takes startingrow (etc.) parameter(s)

step 3) -- virtualize database based on json service.

so, not trivial task, right way solve this. there plenty of examples each of these steps.

-- followup should have been clearer, datatables slow if have lots of data, never recommend using without virtualization if have 1000 rows of 20 columns, sluggish me. if use support old ie of course slower normal.


Comments

Post a Comment

Popular posts from this blog

java - Run a .jar on Heroku -

-
i trying run .jar file on heroku, , can't find instructions anywhere on how this. have read wants me compile uploading heroku. possible, , if is, how this? if helps, trying run minecraft craftbukkit server, , don't have pom.xml file yet. you didn't provide details i'll try give , people reaches question way it. first of all, create heroku account , create heroku application (assumed have done that). second, need generate application jar , upload heroku. so, open terminal , install heroku cli (assuming unix terminal): $ sudo npm install -g heroku-cli you need have npm , nodejs installed, can check link: https://www.digitalocean.com/community/tutorials/how-to-install-node-js-on-ubuntu-16-04 once done that, can use npm update node version acceptable heroku-cli: $ sudo npm install -g n $ sudo n 7.10.0 and run: $ sudo npm install -g heroku-cli in order deploy jars, need install deploy plugin: $ sudo heroku plugins:install heroku-cli-deploy ...
Read more

java - Jtable duplicate Rows -

-
Image
when add new rows in jtable duplicate rows many times this method update jtable public final void tableaucomande(){ ((defaulttablemodel)tabcommande.getmodel()).getdatavector().clear(); session s=hibernateutil.getsessionfactory().opensession(); criteria cr1= s.createcriteria(commande.class); list <commande> lcs=cr1.list() ; criteria cr2= s.createcriteria(lignecommande.class); list <lignecommande> lck=cr2.list() ; if(lcs.size()!=0 && lck.size()!=0) { (commande lc:lcs) { for(lignecommande lig:lck){ ((defaulttablemodel)tabcommande.getmodel()).addrow(new object[]{ lc.getid_cmd(),lc.getnumcmd(),lc.getdate_cmd(),lc.getclient().getnomprenom(), lig.getproduit().getlib_prd(),lig.getquantite(),lig.getproduit().getid_prd() }); } } // tabcommande.setrowselectioninterval(tabcommande.getrowcount()-1,tabcommande.getrowcount()-1); } } this code add add data rows displaye...
Read more

validation - How to pass paramaters like unix into windows batch file -

-
i need pass various parameters .cmd file unix format file.cmd -configuration=value -source=value -flag but, try this: startlocal @echo off cls setlocal set cmdline=%* set configuration= set source= set badargs= set validation= goto main :splitargs echo splitargs(%*) if "%*" neq "" ( /f "tokens=1,2,* delims== " %%i in ("%*") call :assignkeyvalue %%i %%j & call :splitargs %%k ) goto :eof :assignkeyvalue echo assignkeyvalue(%1, %2) if /i %1==-configuration ( set configuration=%2 ) else if /i %1==-source ( set source=%2 ) else ( rem append unrecognised [key,value] badargs echo unknown key %1 set badargs=%badargs%[%1, %2] ) goto :eof :validate echo validating set validation=fail if defined configuration ( echo -configuration ok if defined source ( echo -source ok if not defined badargs ( set validation=success ) ) ) goto :eof :main cl...
Read more