Hi,

I think I find the issue of my problem.

It would be indeed an obviousness for you and that's why you didn't talk about it.

In fact, I didn't set the LoadStyle property to LoadOnDemand.

With this line of code, my grid loads in 610 ms. It's great !

this.grdClient.DisplayLayout.LoadStyle = Infragistics.Win.UltraWinGrid.LoadStyle.LoadOnDemand;

David

Hi David,

I agree with Trent - the trial version is the same codebase and you can simply activate your demo version without having to reinstall it.

I would recommend that you turn off any advanced grid features to see if that helps. If it does it is then a case of tracing the culprit. Infragistics have a number of built-in presets that you can access from the Ultragrid designer and you can drastically change the grid's behaviour with a couple of mouse clicks.

Some features will have an impact on performance with large recordsets. For example, if you have row summaries turned on I would try turning them off first. Also, are you using the grid to set the sort order or are you taking the natural order supplied by the BO? Have you added any formating code in your source code that effects the grid?

Unfortunately, there are so many possibilities it is difficult to comment without knowing more. Could you send or post a screenshot of your grid with some data loaded?

Regards,

Aaron

The trial should make no difference as you have the full functionality of the software.  Just the license is time limited and you do not get the source code.  So that should not be a factor.

Hi Aaron

Is the difference due of the fact that I have a trial version of Infragistics ?

Thanks

David

I am on-board with what Aaron is say as we too use the Infragistics grid in our medical software...though sparingly.  There are in the neighborhood of 3000 properties (or more) on the Infragistics grid...which is insane and frustrating.  In fact, we found a property the other day that sped up performance on something that we were doing...if I could recall what it was I would tell you, but I don't think this particular property would affect what you are trying to do.

This is one reason that we are very careful on using too many 3rd party tools and we, like you, spend a good amount of time testing performance and optimization, which definitely pays off in the long run.

I am sorry that I cannot be more help with the Infragistics grid...if you get a chance, you may throw a post out on their forum and see if they have any ideas.

I have used Infragistics grids for many years and I don't recall noticing any performance changes between versions. There is no doubt that an Infragistics grid has much more power and features over the built-in Windows grid and this should translate to slower initialization. However, I have never tried the simple windows grid as I need the Infragistics features and don't have speed issues.

I would suggest you check which features you have turned on in the Infragistics grid - try turning off as many advanced features that you can to bring it down to the same level as the windows grid.

Also, take a look at the Infragistics grid code in the form Designer file as I have seen the UltraGrid Designer put unnecessary code in here if a lot of changes have been made. I remember being able to remove about 100 lines of initialization code that the designer had inserted which effectively cancelled each other out - the code was simply unnecessary.

Now that you know the SF BBS is not the cause and that the windows grid is faster, I would recommend posting a message on the Infragistics technical forum as well. They may be able to give you an insight into why the two grids perform differently.

Aaron

Hello,

I made tests yesterday with Michel. We found the cause of the slow loading of my records.

We made tests with a win grid classic instead of a Infragistics grid and the time of loading is 270 ms for 20 000 records ! It's quite better I'm impressed !

I did tests with a database with 433 000 records this morning and the result is 7.2 sec.

So, according to Michel and I, the problem comes from the Infragistics grid. I downloaded a trial version (NetAdvantage for .NET 2008 Vol. 2 : Bundle [.NET 3.0]) Could it be possible that the slow loading is due to the version ?

David

Aaron is right on the money here.  You first need to see where your bottleneck is.  The very first thing that you would need to do is open up SQL Server Management STudio and turn on the profile timings (SET STATISTICS TIME ON) and see how long it takes to execute the query and return the result set.  Then go from there.

I would check how long it takes to simply execute the SQL query inside SQL Server Management Studio. If the query isn't optimized or if the SQL Server engine itself is slow there is little you will do in code. There are many factors outside of your code that can affect the performance as you can see from the significant performance drop when using the debugger.

But 20 seconds is better than 4 minutes.

Sure it's better but it seems a little bit to long for my boss
I'll search to improve my code.