Yes, 20 seconds is better and you should be able to get faster. The debugger is causing the delay. Are you happy with 20 seconds?

You could probably still improve on the performance...but there is a vast difference between 20 seconds and 4-5 minutes.

I'm running my application with F5 bulid in VS

I try with ctrl + F5 and I load my 20 000 records in 20 seconds

David

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?

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

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

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.

Aaron also has a good point.

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.

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