I am using asp.net grid view with sql datasource, this gridview will be triggered on update of any of the 6 dropdowns filters and I am using update panel and trigger to update on selectedindexchange event but all this does not seem to be working efficiently.
When I change a filter dropdown the gridview take about 20 sec to reload itself which is very bad.
Please suggest how I can imporve its performance and I know there are not many records also.
I am open to consider a different solution also.
The sqldatasource procedure takes around 6sec but the remaining time is delay with gridview and this is not accepted.