WebGrid too slow , white screen is displayed

handy@intersoftpt.com — Wed, 31 Mar 2010 06:03:36 GMT

Hello,

I could not investigate the issue beased on the aspx code. Would you mind to send me a runable simple sample?
The issue in community center, depends on your internet connection and browser. It is not the same issue because our Community center doesn't use WebGrid at all (uses div).

Regards,
Handy

WebGrid too slow , white screen is displayed

farazhasan — Wed, 31 Mar 2010 03:25:30 GMT

Hi Handy,

Replication of the issue is a bit difficult, because we are using SQL 2005 and fetching data from different tables, Access will not fullfill our requirement. We have been using your components since the last 6 years, so be sure we know how to use vitual paging . We were using 2003 components. We have upgraded to 2008 just 10-12 months back. We never had any issues with the old 2003 WebGrid. But this 2008 webgrid is a bit slow in fetching the data. I am using procedures to get data from the tables.

When I click your community link even then I get a blue screen (refer to screenshot) and it takes atleast 1 minute to get the data, Is this the same issue. If it is then How did you change the color and can we add some text on it.

this is just an example of the binding code with procedure.

<ISWebGrid:WebGrid ID="wgAnnualAppraisalAppraiserGoalSheet" runat="server" DataSourceID="sqldsGoalSheet" UseDefaultStyle="True" RuntimeLicenseKey="---------------" Height="200px"> <LayoutSettings GridLines="Vertical" AllowFilter="Default" PagingMode="VirtualLoad" AllowColumnFreezing="Default" AllowColumnSizing="Default" AllowContextMenu="False" RowHeightDefault="" AllowEdit="Yes"> <ClientSideEvents OnRowSelect="wgAnnualAppraisalAppraiserGoalSheet_OnRowSelect" /> </LayoutSettings> <RootTable DataKeyField="GoalsId"> <Columns> <ISWebGrid:WebGridColumn AllowMultiLine="True" Caption="Goals Statement" DataMember="GoalsStatement" EditType="NoEdit" Name="GoalsStatement" Width="180px"> </ISWebGrid:WebGridColumn> <ISWebGrid:WebGridColumn AllowMultiLine="True" Caption="Start Date" DataFormatString="dd-MMM-yyyy" DataMember="StartDate" DataType="System.DateTime" EditType="NoEdit" Name="StartDate" Width="75px"> </ISWebGrid:WebGridColumn> <ISWebGrid:WebGridColumn AllowMultiLine="True" Caption="End Date" DataFormatString="dd-MMM-yyyy" DataMember="EndDate" DataType="System.DateTime" EditType="NoEdit" Name="EndDate" Width="75px"> </ISWebGrid:WebGridColumn> <ISWebGrid:WebGridColumn AllowMultiLine="True" Caption="Appraisee's Rating" DataMember="AppraiseeRating" EditType="NoEdit" Name="AppraiseeRating" WebComboID="wcApprAchRating" Width="70px"> <ValueList DataMember="DefaultView" DataSourceID="dssqlAppraiserAchievementRating" DataTextField="RatingDesc" DataValueField="RatingID"> </ValueList> </ISWebGrid:WebGridColumn> <ISWebGrid:WebGridColumn AllowMultiLine="True" Caption="Validation" DataMember="AppraiserGoalRating" EditType="NoEdit" Name="AppraiserGoalRating" WebComboID="wcApprGoalRating" Width="75px"> <ValueList DataMember="DefaultView" DataSourceID="dssqlApprasierGoalRating" DataTextField="RatingDesc" DataValueField="RatingID"> </ValueList> </ISWebGrid:WebGridColumn> <ISWebGrid:WebGridColumn AllowMultiLine="True" Caption="Appraiser's Rating" DataMember="AppraiserAchievementRating" EditType="NoEdit" Name="AppraiserAchievementRating" WebComboID="wcApprAchRating" Width="85px"> <ValueList DataMember="DefaultView" DataSourceID="dssqlAppraiserAchievementRating" DataTextField="RatingDesc" DataValueField="RatingID"> </ValueList> </ISWebGrid:WebGridColumn> <ISWebGrid:WebGridColumn AllowMultiLine="True" Caption="Submitted By" DataMember="SubmittedByName" EditType="NoEdit" Name="SubmittedByName" Width="70px"> </ISWebGrid:WebGridColumn> </Columns> </RootTable> </ISWebGrid:WebGrid> <asp:SqlDataSource ID="sqldsGoalSheet" runat="server" ConnectionString="<%$ ConnectionStrings:PESystemConnectionString %>" SelectCommandType="StoredProcedure" SelectCommand="ProcPEAnnualAppraiserGoalSheetGetDetails"> <SelectParameters> <asp:Parameter Name="EmpId" Type="Int32" DefaultValue="0" /> </SelectParameters> </asp:SqlDataSource>

WebGrid too slow , white screen is displayed

handy@intersoftpt.com — Tue, 30 Mar 2010 22:50:21 GMT

Hi Faraz,

WebGrid should be working fine. You can try to run our WebGrid sample and it will show you how it works. Maybe you used incorrect way in implementing Virtual Load or bind WebGrid. So, If it is possible, would you mind to send a simple runable sample which replicates this issue?

Regards,
Handy

WebGrid too slow , white screen is displayed

farazhasan — Tue, 30 Mar 2010 09:28:44 GMT

Hi,

I am using webGrid.net 6.0 in my application, The issue is that while loading the data it is taking alot of time, even though virtual paging has been done and we are fetching only 50 records at a time.

We are getting data from different tables onto 1 form.

As soon as we click the button(refer to screen shot: calling the grid page) to go to the page, a white screen appears (refer to screen shot: Blankscreen) , this is where the data is being loaded.

Issue is that some times it takes upto 2 mins to load the data and the users thinks that the page is not working.

Is it possible we can make the data loading fast or put some kind of remark or an animated gif image which would tell the user that the page is getting processed.

Intersoft Community - WebGrid Enterprise - WebGrid too slow , white screen is displayed

WebGrid too slow , white screen is displayed

WebGrid too slow , white screen is displayed

WebGrid too slow , white screen is displayed

WebGrid too slow , white screen is displayed