It takes too long to execute a query in aspx page
-
Dear All, I am having an issue with an aspx where it takes too much (more than 1 min) to execute a page as it only takes 2 second in sql server to execute the same query where i am calling from aspx page. I didn't understand why the aspx page takes too much time?
Abdul Rahaman Hamidy Database Developer Kabul, Afghanistan
-
Dear All, I am having an issue with an aspx where it takes too much (more than 1 min) to execute a page as it only takes 2 second in sql server to execute the same query where i am calling from aspx page. I didn't understand why the aspx page takes too much time?
Abdul Rahaman Hamidy Database Developer Kabul, Afghanistan
I've heard that before. In most case, one binds a table to a control, and that table has over 10K records. Of course in SQL, it returns in 2 secs, but the overhead on the server, takes, several minutes to generate the HTML code, and the download time as well.
-
I've heard that before. In most case, one binds a table to a control, and that table has over 10K records. Of course in SQL, it returns in 2 secs, but the overhead on the server, takes, several minutes to generate the HTML code, and the download time as well.
Yep, I agree with jKirkerx. You haven't given enough information about the nature of your aspx page. What controls are on it ? What is the action that is being performed by the SQL engine. 2 seconds of execution time on a SQL server could effect tens of thousands of rows of data. My hunch is that you are dealing with lots of data and maybe you should reconsider your page design. Give some more information and the folks here will give you suggestions for improvement. :thumbsup: