Re: Issue with retrieving large data over web using Stored Procedu

Hi Bob,

Thanks for all your help.
You know what. I found a solution.

I realized that the tables at the new server did not have have proper indexes.
The indexes did not copy over properly to the new server.
I will try that first.

Then, if it still cause so much delay, then I would create a new procedure
or try other approach.

Thanks.

"Bob Barrows [MVP]" wrote:

Frankly, no. ASP is really not designed for activities that take this long
to complete. If the procedure cannot be tuned to return results in less than
a minute, then I would suggest you move that functionality into a scheduled
task that populates a table with the results from the procedure. Then create
another procedure to be called from ASP to retrieve results from that table.
It should be much quicker unless you are doing something silly like
retrieving millions of rows of data.

Justin Doh wrote:
I think I know how to analyze the query.

Beside what the recommendation stated here (mostly index), is there
any other improvements I could do at the ASP page?


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"



.

Relevant Pages

  • Re: What are the best general things to do after a dirty shutdown (Server SBS)
    ... Microsoft Windows Small Business Server 2003 Best Practices Analyzer ... After that, please post any event log errors, just the EventID# and Source names, not the whole error message. ... error 15100 Win32 Error 15100. ... One is indicating it can't retrieve info about the System log. ...
    (microsoft.public.windows.server.sbs)
  • Re: ruby-lang emails getting blocked
    ... an email with one of the spam trap address as the from was bounced by the ... so no human checks to see if the message was a bounce. ... spamcop would probably still list the server as a spam ... I have not been an active user of spamcop for some time. ...
    (comp.lang.ruby)
  • Re: Serivce Pack 2 for Windows 2003 enterprise server fails
    ... MVP - Windows Server - Clustering ... 496.391: GetCatVersion: Failed to retrieve version information ...
    (microsoft.public.windows.server.clustering)
  • Re: POP3 Connector hiding mail
    ... I have tried to do the setup and to trigger the settings for the server ... the Microsoft help in troubleshooting the POP3 connector. ... to be able to retrieve emails on demand. ... messages to a mapped user mailbox. ...
    (microsoft.public.windows.server.sbs)
  • Re: Problem installing SharePoint 2007 Enterprise
    ... SharePoint Products and Technologies Configuration Wizard ... lock to retrieve the state ... registry key from under Software\Microsoft\Shared Tools\Web Server ...
    (microsoft.public.sharepoint.windowsservices)
Loading