By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,846 Members | 1,646 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,846 IT Pros & Developers. It's quick & easy.

datagrid too slow

P: n/a
In my application I have a datagrid. The code calls a Stored procedure and
brings like 200 records. I created a dataset and then a dataview to bind the
results of the query to my grid using MyGrid.DataBind() Once the
records are loaded, to handle the next, previous button is too slow. I have
in the same screen OptionsBox and everytime I click in any option I show
some text fields in the screen. Anything the user does is very slow. When my
query returns less than 100 records everything is fast but when I load more
records in the datagrid is slow. If this is in memory why is it so slow? In
real time application I will bring more than 1000 registers and this can';t
be so slow.

This definitions I'm doing only once in the code
Dim myds As New DataSet

Dim mydv As New DataView

What can I do to improve and make it fast? I've work with VB 6.0 and once
the info. is loaded in the grid it was so fast not like the machine is
thinking a lot

Thanks in advance

Jennyfer
Nov 18 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
It doesn't sound like the bottleneck here is asp.net, but your stored procedure. I'd ensure you are doing good coding practices there, and also make sure you have optimized how the data is being stored in sql server. (primary keys set, indexes?) You could write books on that kind of optimization though.

"Jennyfer J Barco" <pd*****@nospam.wdsinc.com> wrote in message news:u5**************@TK2MSFTNGP09.phx.gbl...
In my application I have a datagrid. The code calls a Stored procedure and
brings like 200 records. I created a dataset and then a dataview to bind the
results of the query to my grid using MyGrid.DataBind() Once the
records are loaded, to handle the next, previous button is too slow. I have
in the same screen OptionsBox and everytime I click in any option I show
some text fields in the screen. Anything the user does is very slow. When my
query returns less than 100 records everything is fast but when I load more
records in the datagrid is slow. If this is in memory why is it so slow? In
real time application I will bring more than 1000 registers and this can';t
be so slow.

This definitions I'm doing only once in the code
Dim myds As New DataSet

Dim mydv As New DataView

What can I do to improve and make it fast? I've work with VB 6.0 and once
the info. is loaded in the grid it was so fast not like the machine is
thinking a lot



Thanks in advance

Jennyfer

Nov 18 '05 #2

P: n/a
The first time it loads the page, it calls the sp and is bringing the info.
very fast. The grid appears so fast. The thing is that if there are many
records in the grid working with the controls is very slow. Making a
Options_SelectedIndexChanged which is an option radiobuttonlist is very
slow. When I bring to the datagrid a few records executing this
Options_SelectedIndexChanged is very fast. I traced the program and I know
calling the SP and doing the databind is not slow even if he is returning me
thousands of records. It's when I load many records in the grid the problem.
In the Page_Load I call the SP only when is not Ispostback which means the
first time because I know .NET runs the page_load everytime you do anything
like moving to the next page or select an option in the radiobuttom.

Thanks

"Raterus" <ra*****@spam.org> wrote in message
news:Ox**************@TK2MSFTNGP11.phx.gbl...
It doesn't sound like the bottleneck here is asp.net, but your stored
procedure. I'd ensure you are doing good coding practices there, and also
make sure you have optimized how the data is being stored in sql server.
(primary keys set, indexes?) You could write books on that kind of
optimization though.

"Jennyfer J Barco" <pd*****@nospam.wdsinc.com> wrote in message
news:u5**************@TK2MSFTNGP09.phx.gbl...
In my application I have a datagrid. The code calls a Stored procedure and
brings like 200 records. I created a dataset and then a dataview to bind the results of the query to my grid using MyGrid.DataBind() Once the
records are loaded, to handle the next, previous button is too slow. I have in the same screen OptionsBox and everytime I click in any option I show
some text fields in the screen. Anything the user does is very slow. When my query returns less than 100 records everything is fast but when I load more records in the datagrid is slow. If this is in memory why is it so slow? In real time application I will bring more than 1000 registers and this can';t be so slow.

This definitions I'm doing only once in the code
Dim myds As New DataSet

Dim mydv As New DataView

What can I do to improve and make it fast? I've work with VB 6.0 and once
the info. is loaded in the grid it was so fast not like the machine is
thinking a lot

Thanks in advance

Jennyfer

Nov 18 '05 #3

P: n/a
Do you have any idea of this? The problem is not the sp that brings the
data, it's very fast. The problem is when I load hundreds of records. Isn't
this design to work with a lot of information?

Thanks and help please

Jennyfer

"Jennyfer J Barco" <pd*****@nospam.wdsinc.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
The first time it loads the page, it calls the sp and is bringing the info. very fast. The grid appears so fast. The thing is that if there are many
records in the grid working with the controls is very slow. Making a
Options_SelectedIndexChanged which is an option radiobuttonlist is very
slow. When I bring to the datagrid a few records executing this
Options_SelectedIndexChanged is very fast. I traced the program and I know
calling the SP and doing the databind is not slow even if he is returning me thousands of records. It's when I load many records in the grid the problem. In the Page_Load I call the SP only when is not Ispostback which means the
first time because I know .NET runs the page_load everytime you do anything like moving to the next page or select an option in the radiobuttom.

Thanks

"Raterus" <ra*****@spam.org> wrote in message
news:Ox**************@TK2MSFTNGP11.phx.gbl...
It doesn't sound like the bottleneck here is asp.net, but your stored
procedure. I'd ensure you are doing good coding practices there, and also
make sure you have optimized how the data is being stored in sql server.
(primary keys set, indexes?) You could write books on that kind of
optimization though.

"Jennyfer J Barco" <pd*****@nospam.wdsinc.com> wrote in message
news:u5**************@TK2MSFTNGP09.phx.gbl...
In my application I have a datagrid. The code calls a Stored procedure and brings like 200 records. I created a dataset and then a dataview to bind the
results of the query to my grid using MyGrid.DataBind() Once the
records are loaded, to handle the next, previous button is too slow. I

have
in the same screen OptionsBox and everytime I click in any option I show
some text fields in the screen. Anything the user does is very slow. When my
query returns less than 100 records everything is fast but when I load

more
records in the datagrid is slow. If this is in memory why is it so slow?

In
real time application I will bring more than 1000 registers and this

can';t
be so slow.

This definitions I'm doing only once in the code
Dim myds As New DataSet

Dim mydv As New DataView

What can I do to improve and make it fast? I've work with VB 6.0 and

once the info. is loaded in the grid it was so fast not like the machine is
thinking a lot

Thanks in advance

Jennyfer


Nov 18 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.