Hello,
First of all, I'm a french developper so sorry for my english and if I make mistakes.
I'm using Infragistics grid in my project. I'm testing StrataFrame and I made tests to compare the time of grid loading.
With a Infragistics grid, the time of loading for 20 000 records is 26 seconds.
When I used a windows grid, this time is only 700 ms.
Infragistics components and Strataframe aren't compatible ?
I wonder why a such difference. I'm aware that the Infragistics grid has much more power and features over the built-in Windows grid and this should translate to slower initialization but I think my tests results are strange.
Have you ever heard about this ?
Did I put wrong parameters ?
Thanks for your help
David
David,
I don't know anything about StrataFrame, but that does sound like a very long time for loading those records. Is the data hierarchical? One thing to test would be to set the SyncWithCurrencyManager property to False. If your data is hierarchical, especially if it's recursive, you could set the DisplayLayout.MaxBandDepth to something small, like 3-5.
-Matt
Matt,
Thanks for your help. I set the SyncWithCurrencyManager property to False and the result is still 26 seconds. And it's the same with the DisplayLayout.MaxBandDepth set to 5.My data come from a Customer table with 4 columns (Id, Name, ZipCode and Address) without relation with other tables.
I posted a message on StrataFrame's forum and many users of both StrataFrame and Infragistics have no problem of long time loading. I have no idea which parameters are wrong.
Any other idea ?
Thanks.
Nothing else comes to mind, especially if you don't have any relations in your code. Can you reproduce the issue using a .NET DataTable? I ask because this sounds like about the time that was required to try to validate a VeriSign'ed assembly if you don't have an internet connection; if you have this problem and your internet connection is working, then this is a moot point. You may want to submit a sample to Developer Support.
Are you handling any events of the grid? Perhaps something you are doing in an event is causing it to be slow?
Are you applying Appearances to any of the grid objects?
Are you using ValueLists in your grid?
The grid needs to load all rows when performing sorting or summaries, since it needs to access all of the data in order to be able to perform these operations.
In fact, it works only if I have no summary rows or no column sorted.
So, the problem still exists :(
I go on my searchs.
Hi Mike,
I think I find the issue of my problem.
It would be indeed an obviousness for you. I didn't set the LoadStyle property to LoadOnDemand.
this.grdClient.DisplayLayout.LoadStyle = Infragistics.Win.UltraWinGrid.LoadStyle.LoadOnDemand;
I just populate my DataSource with the BO specific of StrataFrame. I'm not handling any event and I don't use ValueList.
I just finished a sample project to see the difference between a WinGrid and an Infragistics Grid. Can I send it to you ?