Rank: Newbie
Groups: Member
Joined: 8/19/2012
Posts: 2
|
How to improve the speed?
If I use this code and standard grid view working very very very fast!
FirebirdSql.Data.FirebirdClient.FbCommand fbComm = app.GetExpNoteItems(sID);
fbComm.Connection.Open();
GridView1.DataSource = fbComm.ExecuteReader();
GridView1.DataBind();
fbComm.Connection.Close();
If I use:
FirebirdSql.Data.FirebirdClient.FbCommand fbComm = app.GetExpNoteItems(sID);
fbComm.Connection.Open();
Grid1.DataSource = fbComm.ExecuteReader(); // Grid1 = EO.WEB.Grid
Grid1.DataBind();
fbComm.Connection.Close();
Execution of code takes more of 40s for table with 40 records.
If I use MS Grid View execution of code takes less than 0.5s
PLEASE HELP ME!
|
Rank: Administration
Groups: Administration
Joined: 5/27/2007
Posts: 24,195
|
Hi,
You will want to reduce the number of the columns and also use server side paging if possible. Our Grid is very different than ASP.NET GridView and it has a lot more overhead in order to provide various features. For example, in order to support client side editing, the Grid keeps all cell data on the client side. As such if you have a large amount of data, you should consider using server side paging so that only a portion of the data is loaded.
Thanks!
|
Rank: Newbie
Groups: Member
Joined: 8/19/2012
Posts: 2
|
Thanks!
|