I am coming across this problem that whenever I am trying to retrieve the data in a dataset Through database, it is taking around 10 min to get the data no the localhost. And when I am running the same code on the live server it doesnot take time at all and I get the data in few minutes only.
My dataset Contains around 25rows and each row containing 12 columns.
I am getting this problem only in retrieving this particular dataset. Rest all are not taking time to get the data.
Can anyone tell me the solution to this.
Thanks in advance :)