asp.net - Performance Issues loading large data set into c# GridView -


ok,

been testing relatively small data sets gridview, , has worked fine. however, i've moved proper uat , have tried load 17,000 records grid, has brought web app grinding halt.

basically, user logs in, , upon validation data grids loaded, 1 of contains 17k records. until loads end user left handing on logon page. need fix it.

the code grids is:

datatable dtvaluedatecurrency = null;                sqlconnection conn = new sqlconnection(webconfigurationmanager.connectionstrings["reporting"].connectionstring); using (conn) {     conn.open();     //load other grid data     using (sqldataadapter sqladapter = new sqldataadapter(tsql1, conn))     {         dtvaluedatesummary = new datatable();         sqladapter.fill(dtvaluedatesummary);         grdvaluedatesummary.datasource = dtvaluedatesummary;         grdvaluedatesummary.databind();     }  }

is there way increase load times? pagination isn't option, i'm taking care of jquery.

loading 17,000 records in 1 query what's killing you. highly suggest paging gridview.

first need alter stored procedure follows.

alter procedure [dbo].[sometable_getpagedresults]  (          @startrowindex      int,          @maximumrows        int  )    set nocount on   select      rownum,      [id],      [foo],     [bar]      (select          [id],          [foo],          [bar],          row_number() over(order [id] desc) rownum          dbo.[sometable] t)  derivedtablename  rownum between @startrowindex , (@startrowindex + @maximumrows)

now have pageable query.

you want query complete row count.

alter procedure [dbo].[sometable_getrowcount]    set nocount on   return (select count(id) totalrecords sometable)

you'll bind grid every time change page.

protected void gridview1_pageindexchanging(object sender, gridviewpageeventargs e) {   gridview1.pageindex = e.newpageindex;   bindgrid(); // whatever method call bind data , execute stored procedure. }

and bindgrid() method call 2 stored procedures (one complete row count, , 1 results pertaining current page)

additional reading


Comments

Post a Comment

Popular posts from this blog

c++ - End of file on pipe magic during open -

i have c++ application in starting process(wireshark) following. if (fp == null){ fp = popen(processpath, "r"); //processpath process want start if (!fp){ throw std::invalid_argument("cannot start process"); } fprintf(fp, d_msg);//d_msg input want provide process } else if(fp != null){ fprintf(fp, d_msg); } the problem when execute c++ application, start wireshark error end of file on pipe magic during open what should avoid that? also tried using mkfifo create named pipe , execute it. used this: if (fp == null){ system("mkfifo /tmp/mine.pcap"); fp = popen("wireshark -k -i /tmp/mine.pcap", "r"); if (!fp){ dout << "cannot start wireshark"<<std::endl; throw std::invalid_argument("cannot start wireshark"); } input = fopen("/tmp/mine.pcap", "wb"); fprintf(input , d_msg); fclose(input)...
Read more

basic authentication with http post params android -

i doing basic authentication passing username , password , using basicnamevaluepair sending post params response service. my method: public stringbuilder callservicehttppost(string username, string password, string type) { // create new httpclient , post header httpclient httpclient = new defaulthttpclient(); httppost httppost = new httppost(webservice + type); httpresponse response = null; stringbuilder total = new stringbuilder(); try { url url = new url(webservice + type); /*string base64encodedcredentials = base64.encodetostring((username + ":" + password).getbytes(), base64.url_safe | base64.no_wrap);*/ string base64encodedcredentials = "basic " + base64.encodetostring( (username + ":" + password).getbytes(), base64.no_wrap); httppost.setheader("auth...
Read more

data.table making a copy of table in R -

i doing this: myfun <- function(inputvar_vec){ # inputvar_vec input vector # # result = output vector return(result) } dt[, result := lapply(.sd, myfun), = byvar, .sdcols = inputvar] i getting following warning: warning message: `in `[.data.table`(df1, , `:=`(prop, lapply(.sd, propeventinlastk)), : invalid .internal.selfref detected , fixed taking copy of whole table, := can add new column reference. @ earlier point, data.table has been copied r (or been created manually using structure() or similar). (and more stuff) .... ` my guess because stacking result vectors (after operation), copy being made? can suggest method remove warning? have done using apply functions , thought should extendable here too. my other question is: can pass chunk of rows data frame (subsetted using statement), , call function myfun operate on that? adding example requested # generate data n = 10000 default=na value = 1 df = data.table(id = sample(1:5000, n, replace=true), ...
Read more