Large Stored Proceedure
-
I am building datasets at run time from asn asp.net c# web page. My chalenge is one of my stored proceedures has to harvest an extremely large dataset depending on the date range selected. My question is how to I set the progress of the stored proceedure? Here is a scenario if the data range is this month or this week the proceedure will run in a small period of time maybe 15 seconds. But if they choose to run the dataset going back one full year then it will take atleast 5 mins to generate the appropriate data. How to I make the asp.net webpage wait until that proceedure is done? Thanks
-
I am building datasets at run time from asn asp.net c# web page. My chalenge is one of my stored proceedures has to harvest an extremely large dataset depending on the date range selected. My question is how to I set the progress of the stored proceedure? Here is a scenario if the data range is this month or this week the proceedure will run in a small period of time maybe 15 seconds. But if they choose to run the dataset going back one full year then it will take atleast 5 mins to generate the appropriate data. How to I make the asp.net webpage wait until that proceedure is done? Thanks
wait how ? Your page is going to timeout in five minutes. Your best bet is to have another process, such as a windows service, do the stored proc call, and have your page auto postback, or use AJAX, to work out when the process has ended, and the data can be loaded by the page.
Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )