page timesout
-
VickyC# wrote:
I wonder if in IIS there is a limit on the page size
Are you running your web app and database on the same machine or are you fetching the data over the network? Since your stored proc is only pulling out 27 records, it shouldn't be close to any page size limit. How quick does the stored proc run by itself when shot through query analyzer?
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
-
No they are on different machines. It is 27 columns 2-50 rows. But this is a part of a fairly sizable page. The stored procedure in SQL Query analyzer takes less than 2 seconds in the worst case.
-
No they are on different machines. It is 27 columns 2-50 rows. But this is a part of a fairly sizable page. The stored procedure in SQL Query analyzer takes less than 2 seconds in the worst case.
Since it is only 27 columns with 2-50 rows, that shouldn't be very heavy weight at all. If you don't mind me asking, what are the other things going on in the page since you say it is a fairly sizable page?
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
-
Since it is only 27 columns with 2-50 rows, that shouldn't be very heavy weight at all. If you don't mind me asking, what are the other things going on in the page since you say it is a fairly sizable page?
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
There are just similar queries that provide sales analysis and forecasting. 9 gridviews 2 dropdown list boxes, 7 radio buttons, 1 textbox, 1 button, 8 sqldatasources. The total size of the aspx is about 189k. But at any given time only a few of these are activated.
-
There are just similar queries that provide sales analysis and forecasting. 9 gridviews 2 dropdown list boxes, 7 radio buttons, 1 textbox, 1 button, 8 sqldatasources. The total size of the aspx is about 189k. But at any given time only a few of these are activated.
How many of these other features of the page are running along side with the stored proc in question? Are the other gridviews, dropdowns, and 8 datasources active when you run the stored proc? Sounds like a pretty heavy duty page. Just trying to visualize it :-D Not sure of how much more assistance I can be, but there must be some silly thing going on here. I'd just look through everything and see what is bottlenecking your page. Even with all the features you mention, it should be within reasonable bounds.
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
-
How many of these other features of the page are running along side with the stored proc in question? Are the other gridviews, dropdowns, and 8 datasources active when you run the stored proc? Sounds like a pretty heavy duty page. Just trying to visualize it :-D Not sure of how much more assistance I can be, but there must be some silly thing going on here. I'd just look through everything and see what is bottlenecking your page. Even with all the features you mention, it should be within reasonable bounds.
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
It is a heavy duty page but as you say is just a silly thing. 1. At any given time only a single selection is done 2. Just pass parameters to an sql data source. 3. The stored procedure(s) do the work. 4. Analyze/format/populate the data into a grid view. 5. Trigger via the selection item of the main grid 2 more detailed grid views. The process is repeated for the detailed gridviews. Sometimes there is no page expiration. But then some times when larger datasets are called then for sure there will be a page timeout. It all way though happens on the gridview databind. The larger datasets are not that large (50 recs vs 2). The underlying data of the stored procedure contain lot of data. But how could this be relevant? On stand alone page there is no issue. But I would hate to separate the gridviews since they provide an nice concise presentation.
-
It is a heavy duty page but as you say is just a silly thing. 1. At any given time only a single selection is done 2. Just pass parameters to an sql data source. 3. The stored procedure(s) do the work. 4. Analyze/format/populate the data into a grid view. 5. Trigger via the selection item of the main grid 2 more detailed grid views. The process is repeated for the detailed gridviews. Sometimes there is no page expiration. But then some times when larger datasets are called then for sure there will be a page timeout. It all way though happens on the gridview databind. The larger datasets are not that large (50 recs vs 2). The underlying data of the stored procedure contain lot of data. But how could this be relevant? On stand alone page there is no issue. But I would hate to separate the gridviews since they provide an nice concise presentation.
VickyC# wrote:
The underlying data of the stored procedure contain lot of data. But how could this be relevant?
It shouldn't.
VickyC# wrote:
I would hate to separate the gridviews since they provide an nice concise presentation.
I wouldn't. Most sales people I've ever run into, like the big picture. Do you have any code profilers to use? You may want to look at execution paths of your code...
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
-
VickyC# wrote:
The underlying data of the stored procedure contain lot of data. But how could this be relevant?
It shouldn't.
VickyC# wrote:
I would hate to separate the gridviews since they provide an nice concise presentation.
I wouldn't. Most sales people I've ever run into, like the big picture. Do you have any code profilers to use? You may want to look at execution paths of your code...
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
-
VickyC# wrote:
I just need to hit the sack. It has been a long day.
That is a good debugging tool, the pillow :laugh: Maybe tomorrow it'll stand out what is causing the timeouts :-D Have you tried to increase the timeout for both IIS and the database?
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
-
VickyC# wrote:
I just need to hit the sack. It has been a long day.
That is a good debugging tool, the pillow :laugh: Maybe tomorrow it'll stand out what is causing the timeouts :-D Have you tried to increase the timeout for both IIS and the database?
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
-
Hey VickyC#, Good morning and what was your method I should follow? Paul
"You will see a delete button on each of your posts. Press it." - Colin Angus Mackay