New Posts New Posts RSS Feed: Data Lost in Infragistics WebGrid during paging
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

Data Lost in Infragistics WebGrid during paging
 Post Reply Post Reply
Author
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
Rajan View Drop Down
Newbie
Newbie


Joined: 07-Jul-2008
Posts: 4 		Post Options Post Options   Quote Rajan Quote  Post ReplyReply Direct Link To This Post Topic: Data Lost in Infragistics WebGrid during paging
    Posted: 15-Jul-2008 at 6:33am
We are using AspDataSource and bind the same to the Infragistics grid. When we try to bind 450 rows, the application is very slow, so we tried to use the pagination. After implementing the pagination, we have got the first page and when we navigate to next page the grid is empty. Please find below the code that we implemented. Is there anything wrong in the code?
<igtbl:UltraWebGrid ID="uwgABCResults" runat="server" Width="99%" DataSourceID="mABCAspDataSource"

OnInitializeRow="uwgABCResults_InitializeRow" >

<DisplayLayout AutoGenerateColumns="false" SelectTypeRowDefault="Single" Name="ctl00xUltraWebGrid1"

AllowSortingDefault="OnClient" AllowDeleteDefault="No" AllowUpdateDefault="No"

AllowColSizingDefault="Free" RowHeightDefault="20px" TableLayout="Fixed"

RowSelectorsDefault="No" AllowColumnMovingDefault="None" HeaderClickActionDefault="SortMulti"

StationaryMargins="Header" BorderCollapseDefault="Separate" Version="4.00" ScrollBarView="Both">

<FrameStyle Width="99%" Wrap="false" Height="230">

</FrameStyle>

<Pager AllowPaging="true" PageSize="25" StyleMode="ComboBox" >

<PagerStyle BackColor="LightGray" BorderWidth="1px" BorderStyle="Solid">

<BorderDetails ColorLeft="White" ColorTop="White" WidthLeft="1px" WidthTop="1px">

</BorderDetails>

</PagerStyle>

</Pager>

<cc1:AspDataSource ID="mABCAspDataSource" runat="server"

AdapterManagerTypeName="ABC.Adapters.ABCAdapterManager"

AdapterManagerAssemblyName="ABC.Adapters, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null">

</cc1:AspDataSource>
Back to Top
davidklitzke View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 14-Jun-2007
Posts: 715 		Post Options Post Options   Quote davidklitzke Quote  Post ReplyReply Direct Link To This Post Posted: 15-Jul-2008 at 11:31am
I would try to measure how much time is being spent by the AdapterManager retrieving the data and how much time is spent by by the grid displaying the data,  You should be able to set breakpoints in the Adapter Manager code to do this.
 
It might also be useful to compare with another WebGrid such as the .NET GridView.
 
It might also be useful to see if the Adapter Manager has lost the data or has the grid lost the data.
Back to Top
Rajan View Drop Down
Newbie
Newbie


Joined: 07-Jul-2008
Posts: 4 		Post Options Post Options   Quote Rajan Quote  Post ReplyReply Direct Link To This Post Posted: 16-Jul-2008 at 7:50am
I would try to measure how much time is being spent by the AdapterManager retrieving the data and how much time is spent by by the grid displaying the data,  You should be able to set breakpoints in the Adapter Manager code to do this.
First time the adapter manager takes 4-5 seconds and next time onwards it is from the cache so it is very less.
 
It might also be useful to compare with another WebGrid such as the .NET GridView. 
Tried with .NET Grid view with less columns it is rendering fast when compare to .NET Infragistics.
It might also be useful to see if the Adapter Manager has lost the data or has the grid lost the data.
Need to check, during the pagination the SelectEntities event is not firing.
 
Further investigation to the performance issue, i noticed that columns having TypeDescriptors are taking more time. i.e We have nested entities/classes and we are adding type descriptor columns and binding to the grid. The same infragistics control renders fast without these columns. Please find below the code we are using to add the type descriptor.
 
IdeaBlade.Util.PropertyDescriptorList pdl = IdeaBlade.Util.PropertyDescriptorList.Get(typeof(ABC));

pdl.Add("BusinessAddress1", "BusinessAddress.Address1");

ABCD.Business.DevForceTypeDescriptionProvider provider = new ABCD.Business.DevForceTypeDescriptionProvider(typeof(ABC));

System.ComponentModel.TypeDescriptor.AddProvider(provider, typeof(ABC));

Let us know if there is any known issues or any solution for this and the total page render takes more than 3 minutes to display which is un-acceptable to anybody.

Thanks for your time in looking into this.

Rajan R.G
Back to Top
davidklitzke View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 14-Jun-2007
Posts: 715 		Post Options Post Options   Quote davidklitzke Quote  Post ReplyReply Direct Link To This Post Posted: 16-Jul-2008 at 4:33pm
It looks like most of the performance problems are comiong from the Grid, and not the DevForce code, so I don't know if there is a lot you can do.
 
My first thought is to talk to Infragistics and see what they can do for you.  You might get a more favorable response from them if you can show them that performance is a lot better with a different grid.


Edited by davidklitzke - 16-Jul-2008 at 4:34pm
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down