|
| | | StrataFrame Novice
 
Group: Forum Members
Last Login: 09/17/2008 2:16:05 AM
Posts: 54, Visits: 249 |
| | 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 |
| |
| | | 
StrataFrame User
Group: StrataFrame Users
Last Login: Today @ 3:36:53 PM
Posts: 427, Visits: 1,714 |
| | 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 |
| |
| | | StrataFrame Novice
Group: Forum Members
Last Login: 09/17/2008 2:16:05 AM
Posts: 54, Visits: 249 |
| | 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 |
| |
| | | StrataFrame User
Group: StrataFrame Users
Last Login: 09/24/2008 4:17:02 PM
Posts: 151, Visits: 370 |
| | 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 |
| |
| | | 
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Today @ 1:19:33 PM
Posts: 4,556, Visits: 4,542 |
| I want to load 20 000 records. The time to load is very long (around 4-5 min) Is it normal ? 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. |
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Today @ 1:19:33 PM
Posts: 4,556, Visits: 4,542 |
| | Aaron also has a good point. |
| |
| | | StrataFrame Novice
Group: StrataFrame Users
Last Login: Today @ 12:13:03 PM
Posts: 54, Visits: 931 |
| | 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. |
| |
| | | StrataFrame Novice
Group: Forum Members
Last Login: 09/17/2008 2:16:05 AM
Posts: 54, Visits: 249 |
| | 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 |
| |
| | | StrataFrame User
Group: StrataFrame Users
Last Login: 09/24/2008 4:17:02 PM
Posts: 151, Visits: 370 |
| | 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 |
| |
|
|