This is a migrated thread and some comments may be shown as answers.

Different data sources by querystring, very slow performance..

1 Answer 21 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Darren
Top achievements
Rank 1
Darren asked on 19 May 2011, 04:39 PM
Hey folks,

I'm giving the radgrid a shot.  Basically when a user searches a different way, the page_load will direct it what data source to use like so:

If request.querystring("type") = "LocationCategory then
RadGrid1.datasource = sds_search_type_locationcategory
RadGrid1.DataBind()
End if

So i really have two questions. 

#1, is there a better way to do this? I have about 8 different 'types' of searches so the complexity is getting to be a little outrageous. Plus i have to use NeedsDatasource to allow paging/sorting etc which makes it more complex.

#2, Some of my queries return about 10,000 rows, is there a way to show the proper count but not select ALL of that data at once and only select it when its requested?

I cant be the only one out there doing something like this, hopefully i'll get some answers :)

1 Answer, 1 is accepted

Sort by
0
Shinu
Top achievements
Rank 1
answered on 20 May 2011, 05:10 AM
Hello Darren,

Please take a look at the following help article which explains the the grid performance optimization.
Client/server grid performance optimizations.

Thanks,
Shinu.
Tags
Grid
Asked by
Darren
Top achievements
Rank 1
Answers by
Shinu
Top achievements
Rank 1
Share this question
or