Intersoft Community - WebGrid Enterprise - WebGrid's AutoColumnFit Property Performance Issue

WebGrid's AutoColumnFit Property Performance Issue

handy@intersoftpt.com — Mon, 11 Apr 2011 04:05:49 GMT

Hello,

Ok, I understand.
Personally, I don't agree if this issue related to AutoFitColumns.

Example, If I am using WebGrid with few column and few data, It works great (not related to AutoFitColumn).
However, When using Invoice Table which contains many data, I can replicate the issue.
If I adjust the paging, it would work faster than before. The speed even become faster if you set AutoFitColumn true.

It seems the client render in html is less than AutoFitColumn false.
When it set to false, the rendering took many resources such as scrollbar and more elements.
Perhaps, this will answer your question why the performance would be great during AutoFitColumn true.

I would be agree if this performance related to rendering many columns in WebGrid, not because AutoFitColumn.

Regards,
Handy

WebGrid's AutoColumnFit Property Performance Issue

SAgosto — Thu, 07 Apr 2011 10:34:28 GMT

Hi,
I disagree. The solution I created within the February 9, 2011 10:11 post clearly shows a HUGE performance problem. Without the toolbar's child item, the grid refreshes (only 2155 records) in under 2 seconds (acceptable) but nearly 14 seconds with the toolbar's child item. That's nearly 700% increase! That *IS* a performance bug. If this is related to the browser then I suggest fixing the bug by defaulting the necessary CSS as your devs wouldn't know this limitation.

Please pass this information to your development staff as we have had this issue for a very long time and it needs to be addressed.

As I said before, from beginning until the end, we could not replicate the performance issue because of AutoFitColumn.
I already explained that it is true that there is a different time when using AutoFitColumn. But it's still acceptable.

Perhaps, you can send us a simple sample that replicates this issue. We need this to investigate the issue.

Regards,
Handy

Let's forget about the AutoFitColumn. Please refer to the VS solution that I provided which clearly shows the performance bug. I am sorry but 700+% increase in time *IS* a performance problem. I can easily create another solution with some other 3rd party WebGrids that do not have this problem for some comparison. Something is wrong here.

It should not take 14 seconds to display 2,000 records in a simple grid. Whether or not this is a browser issue, it can be resolved with some default CSS which I think you should be fixing on your end. The developers would never know about this limitation and how to fix it.

Please refer to the reproducible VS solutiothat I have provided.

WebGrid's AutoColumnFit Property Performance Issue

handy@intersoftpt.com — Wed, 06 Apr 2011 23:48:13 GMT

Hi,

I disagree. The solution I created within the February 9, 2011 10:11 post clearly shows a HUGE performance problem. Without the toolbar's child item, the grid refreshes (only 2155 records) in under 2 seconds (acceptable) but nearly 14 seconds with the toolbar's child item. That's nearly 700% increase! That *IS* a performance bug. If this is related to the browser then I suggest fixing the bug by defaulting the necessary CSS as your devs wouldn't know this limitation.

Please pass this information to your development staff as we have had this issue for a very long time and it needs to be addressed.

As I said before, from beginning until the end, we could not replicate the performance issue because of AutoFitColumn.
I already explained that it is true that there is a different time when using AutoFitColumn. But it's still acceptable.

Perhaps, you can send us a simple sample that replicates this issue. We need this to investigate the issue.

Regards,
Handy

WebGrid's AutoColumnFit Property Performance Issue

SAgosto — Wed, 06 Apr 2011 15:39:38 GMT

Hello,
Thank you for your valuable feedback. I will let our developer team know about feedback in our CSS. However, I am not sure if also need to be implemented in WebGrid because WebGrid works fine with the default style.
Also, I ever told in previous posts in this thread that I could not replicate very slow performance when using AutoFitColumn. It's true that there is a differences when AutoFitColumn true/false. But the performance is not very slow which is still acceptable in my testing.
Regards,
Handy

I disagree. The solution I created within the February 9, 2011 10:11 post clearly shows a HUGE performance problem. Without the toolbar's child item, the grid refreshes (only 2155 records) in under 2 seconds (acceptable) but nearly 14 seconds with the toolbar's child item. That's nearly 700% increase! That *IS* a performance bug. If this is related to the browser then I suggest fixing the bug by defaulting the necessary CSS as your devs wouldn't know this limitation.

Please pass this information to your development staff as we have had this issue for a very long time and it needs to be addressed.

Thank you.

WebGrid's AutoColumnFit Property Performance Issue

handy@intersoftpt.com — Mon, 04 Apr 2011 08:41:01 GMT

Hello,

Thank you for your valuable feedback. I will let our developer team know about feedback in our CSS. However, I am not sure if also need to be implemented in WebGrid because WebGrid works fine with the default style.

Also, I ever told in previous posts in this thread that I could not replicate very slow performance when using AutoFitColumn. It's true that there is a differences when AutoFitColumn true/false. But the performance is not very slow which is still acceptable in my testing.

Regards,
Handy

WebGrid's AutoColumnFit Property Performance Issue

SAgosto — Fri, 01 Apr 2011 09:48:30 GMT

Hello,
AutoFitColumn can have a different result when set to true or false. When set it true, It will re-calculate all the columns width and resize the column proportionally.
That's why there is a different time. But I could not say it would affect to performance much. Based on my test in my project and your original project, I still could not replicate very slow performance related to AutoFitColumns.
Regards,
Handy

I have solutions in this thread that show that the AutoFitColumns property affects performance dramatically. Please re-read some of the posts in this thread. There were several performance issues and some how that AutoFitColumns property was altering performance. I am not sure if that was the culprit but it definately affected performance dramtically.

I think a change needs to be made to default the CSS in the WebGrid so that this sort of browser bug doesn't exist. You cannot expect your user base to know that they need to specify some CSS to get around this issue.

WebGrid's AutoColumnFit Property Performance Issue

handy@intersoftpt.com — Fri, 01 Apr 2011 07:49:51 GMT

Hello,

AutoFitColumn can have a different result when set to true or false. When set it true, It will re-calculate all the columns width and resize the column proportionally.
That's why there is a different time. But I could not say it would affect to performance much. Based on my test in my project and your original project, I still could not replicate very slow performance related to AutoFitColumns.

Regards,
Handy

WebGrid's AutoColumnFit Property Performance Issue

SAgosto — Thu, 31 Mar 2011 11:43:46 GMT

I removed the child items to avoid this issue. I didn't find a work-around that fixed the performance issue. You should default the necessary CSS so that this issue doensn't occur. One would never know to specify CSS or which CSS to avoid this issue.

Also, I don't understand the correlation between AutoFitColumn with the Grid and this issue but I have spent WAY too much time trying to figure it out.

WebGrid's AutoColumnFit Property Performance Issue

handy@intersoftpt.com — Fri, 11 Feb 2011 03:05:10 GMT

Hi,

What CSS MUST be defined within the WebMenubar/WebToolbar to avoid this performance bug? I am looking for specific Style properties that must be specified and the valid CSS classes and/or style that can be used?

As I told before, by using CSS, AddStyle() method which slow down page in IE. In your latest sample, I can run well in Firefox. Perhaps, you can help us by providing sample that can replicate the issue in firefox.

Why does the WebGrid's AutoFitColumn property fixes this performance bug?

Why does a Split/DropdOWn button within a WebMenubAR/WebToolbar control cause this performance bug? What is specific about this that causes the bug?

I still need to discuss about AutoFitColumn with our developer teams.
Using Split/DropDown button, make WebToolBar/WebMenuBar needs to generate style for its menu.
When need only toolbar command, the menu style does not need to be generated.
So, since the default behavious still use AddStyle(), you need to use CSS to avoid it.

Once again, this is not a bug from our control This is a limitation from IE itself.
Please refer into below community or discussion link to know more information about AddStyle issue:

http://www.webdeveloper.com/forum/showthread.php?p=1112700
http://msdn.microsoft.com/en-us/library/ms906392.aspx
http://www.quirksmode.org/bugreports/archives/2006/01/IE_wont_allow_documentcreateElementstyle.html

I went through the new CSS and made one-by-one changes to narrow down the CSS causing the problem. Our existing application had similiar CSS except some were CSS classes and other was CSS explicitly in the markup. Oddly, the missing css was the following that references an empty CSS class: <CustomStyle CssClass="CustomStyle"></CustomStyle>

Please let me know the detail about what style that you need. CustomStyle is used for Custom MenuItem.
Since, your previous sample, does not use Custom MenuItem, it would be ok if the reference is an empty CSS classes.

Regards,
Handy

WebGrid's AutoColumnFit Property Performance Issue

SAgosto — Thu, 10 Feb 2011 11:40:05 GMT

Hello,

AddStyle() would not be used if you customize all your style with CSS. WebToolBar/WebMenuBar provides properties which can be configured for its style. I already sent you the sample which I include all the style in CSS and set it in those properties.

 <MenuStyleSettings BackgroundStripColor2="" MenuDropShadow="True" MenuAnimation="True"
  MenuWindowType="Normal" BackgroundStripColor="#E3EFFF">
 <CustomStyle CssClass="CustomStyle">
 </CustomStyle>
 <DisabledItemStyle>
 <Over CssClass="DisabledItemStyle-Over">
 </Over>
 <Normal CssClass="DisabledItemStyle-Normal">
 </Normal>
 </DisabledItemStyle>
 <CheckedItemStyle>
 <Over CssClass="CheckedItemStyle-Over">
 </Over>
 <Normal CssClass="CheckedItemStyle-Normal">
 </Normal>
 </CheckedItemStyle>
 <SeparatorStyle CssClass="SeparatorStyle"></SeparatorStyle>
 <FrameStyle CssClass="FrameStyle">
 </FrameStyle>
 <ItemStyle>
 <Over CssClass="ItemStyle-Over">
 </Over>
 <Normal CssClass="ItemStyle-Normal">
 </Normal>
 </ItemStyle>
 </MenuStyleSettings>
 <HeaderButtonStyle>
 <Active CssClass="HeaderButtonStyle-Active">
 </Active>
 <Over CssClass="HeaderButtonStyle-Over">
 </Over>
 <Normal CssClass="HeaderButtonStyle-Normal">
 </Normal>
 </HeaderButtonStyle>
 <BodyStyle BackColor="#BFDBFF"></BodyStyle>
 <CommandStyle>
 <Active CssClass="CommandStyle-Active">
 </Active>
 <Over CssClass="CommandStyle-Over">
 </Over>
 <Normal CssClass="CommandStyle-Normal">
 </Normal>
 </CommandStyle>
 <CommandDisabledStyle CssClass="CommandDisabledStyle">
 </CommandDisabledStyle>
 <SeparatorStyle CssClass="SeparatorStyle1"></SeparatorStyle>
 <HandleStyle BackColor="#BFDBFF"></HandleStyle>
 <OptionStyle BackColor="#C4C4AD"></OptionStyle>
 <HeaderCaptionStyle CssClass="HeaderCaptionStyle">
 </HeaderCaptionStyle>

I will need to discuss with our developer about AutoFitColumn property. But after configure CSS, without AutoFitColumn, the performance works well.

Regards,
Handy

I went through the new CSS and made one-by-one changes to narrow down the CSS causing the problem. Our existing application had similiar CSS except some were CSS classes and other was CSS explicitly in the markup. Oddly, the missing css was the following that references an empty CSS class: <CustomStyle CssClass="CustomStyle"></CustomStyle>

This really makes no sense at all. Please find out from the developers the following:

1) What CSS MUST be defined within the WebMenubar/WebToolbar to avoid this performance bug? I am looking for specific Style properties that must be specified and the valid CSS classes and/or style that can be used?

2) Why does the WebGrid's AutoFitColumn property fixes this performance bug?

3) Why does a Split/DropdOWn button within a WebMenubAR/WebToolbar control cause this performance bug? What is specific about this that causes the bug?

Thank you.

I also verified this is an issue with FIreFox and not just IE.

WebGrid's AutoColumnFit Property Performance Issue

SAgosto — Tue, 20 Oct 2009 17:25:21 GMT

Hey:

I recently upgraded our application from Intersoft 2008 R2 to Intersoft 2009 R1 SP1. Our application is suffering a tremendous performance hit that is being caused by the WebGrid’s AutoColumnFit property. When set to false, the grid takes a tremendous amount of time to render. For example, one page takes nearly 1+ minute to refresh while it takes only 10 seconds when the AutoColumnFit property is set to false. Furthermore, another simple page takes 30 seconds to load vs. 10 seconds when the AutoColumnFit property is set to true. Also, this issue does not occur in the previous release.

Is this a know bug? Can you advise on how to proceed?

Thank you for your help.