S
Samy
Hi There,
I have a stored procedure which takes 7 sec to execute. I am using a
adapter and filling the dataset. Then I bind the datagrid with the
datatable from the dataset. When I test the page against the test
server DB, the page loads pretty fast. When I test the page against the
production server DB, it loads too slowly. The tables against which I
am testing are static tables both in the test DB and the production DB.
I am unable to figure out why it is behaving like this. Can anyone
please help me in this issue?
Thanks a lot.
Samy
I have a stored procedure which takes 7 sec to execute. I am using a
adapter and filling the dataset. Then I bind the datagrid with the
datatable from the dataset. When I test the page against the test
server DB, the page loads pretty fast. When I test the page against the
production server DB, it loads too slowly. The tables against which I
am testing are static tables both in the test DB and the production DB.
I am unable to figure out why it is behaving like this. Can anyone
please help me in this issue?
Thanks a lot.
Samy