Hello,

I'm a strataframe beginner. I want to load several records on a infragistics grid to make tests.

I use a business binding source.

I want to load 20 000 records. The time to load is very long (around 4-5 min) Is it normal ?

Thanks for your help

David

Hi David,

Welcome aboard!

20k records is quite heavy lifting for a any grid to handle.  A user is not likely going to need all those records in order to interact with them.  Is there any way to bring a functional subset to the grid?  Try to keep the record count to around 200.  That seems like a decent number for a grid and a user to handle.

Don't forget, you can add a browse dialog so that user can pick his own records according to his own criteria.

Take care, and enjoy the framework!
Bill

Thanks for your help Bill.

I know that a user doesn't have to use 20 000 records on a grid.

But I just made tests between different frameworks to know their performances.

When I try an other, the records are loaded very quickly compare to StrataFrame 

David

Hi David,

I have just tested an Infragistics grid with 15000 records which runs off an SF BBS. Inside Visual Studio 2008 on a Release build it takes around 3 minutes 20 seconds to open the form when run with debugging. When run without debugging (or when you run the application outside of VS) the time reduces to 7 seconds.

This is not unexpected as VS does place a significant overhead when running an application in debug mode.

Bottom line is you can do it and the above form hasn't been optimized yet.

Regards,

Aaron

You have something setup terribly wrong, then David.  As a test the other day, I had a grid load over 40000 records in less than 5 seconds....so you clearly have something setup wrong here.

How are you even trying to populate and bind to the grid?  Do you have custom properties calling scalar methods in the mix, etc?  Are you using a BusinessBindingSource?  Because if you have this setup right, it will be WAY faster than what you are describing.  In fact, I have never heard of one coming back this slow before (StrataFrame or otherwise).  The other day I was consulting an SF user and they had a form taht was loading 80,000 records.  Aside from the point that they didn't need to bring this many records back, and their query needed to be optimized, it still came back and loaded the grid in around 20-30 seconds in this case.  So I am uncertain of what you may be doing here to produce such poor results.  You are welcome to post your sample, but there is clearly something not right in the mix here.

Aaron also has a good point.

Bonjour David !

un test sur mon portable (Celeron 2Go RAM, SQL Server sur la même machine) me ramène 675000 lignes d'une table dans un grid en 15 secondes.

Hi Trent,

I'm using a BusinessBindingSource

I just load my records by clicking on a button

_

private void btnLoad_Click(object sender, EventArgs e)

{

_chrono.Demarrer();

clientBO1.RetournerTousClients();

chrono.Arreter();

MessageBox.Show(_chrono.Valeur.ToString());

}

and my methods RetournerTousClients() is :

public void RetournerTousClients()

{

this.FillDataTable("SELECT * FROM Client");

}

What do I wrong ?

Thanks for your answers and your help

David

David, are you sure you are not running your application with the F5 build in Visual Studio (which runs with the debugger)? The times you are reporting are precisely what you would get if you are. Instead of using the F5 build try using Ctrl+F5 which will run your application without the debugger.

Other than the above, the only difference with my form is the business object is filled in the ParentFormLoading event.

I would really like to know how you are running your application. Are you running it inside Visual Studio and, if so, how are you running it?

Aaron

Before we dig into any details, I would like to know the answer to Aaron's question as well.  Hvae you tried to just run the EXE from a command line or through Windows Explorer versus through the VS debug environment?