Speed up processes?

Hello. We have some .asp pages running on our W2K Server machine that calls
and runs some stored procedures that's on our other W2K Server SQL Server
2000 machine. We are using https for these web .asp pages and was wondering
if there was any way to speed up the process of the .asp pages outputting
the stored procedures results? I have indexes on the main fields in the
base tables that the stored procedures run. It takes like a minute or so
for the data to display on the .asp pages but have a user asking if there's
a way to speed up the process?

Thanks in advance.

Re: Speed up processes?

J wrote:
> Hello. We have some .asp pages running on our W2K Server machine that calls
> and runs some stored procedures that's on our other W2K Server SQL Server
> 2000 machine. We are using https for these web .asp pages and was wondering
> if there was any way to speed up the process of the .asp pages outputting
> the stored procedures results? I have indexes on the main fields in the
> base tables that the stored procedures run. It takes like a minute or so
> for the data to display on the .asp pages but have a user asking if there's
> a way to speed up the process?
>
> Thanks in advance.

Use QA to test the stored procs to eliminate them as the possible cause
of the delay. If they take a while to execute, try a sql server
programming group for advice on how to rewrite them more efficiently.
Https will always slow things a bit. Does this page really need it?

If the stored procs are fine, and https is required, you will have to
look at the code you are using to output the results. Here's a link to
efficient methods of outputting recordsets:

http://databases.aspfaq.com/database/how-do-i-page-through-a -recordset.html

--
Mike Brind

Re: Speed up processes?

Thanks a bunch for your reply and link Mike. Much appreciated. I'll take a
look at your info.

Take care.

J


"Mike Brind" wrote in message
news:1157792694.296849.323880@h48g2000cwc.googlegroups.com.. .
>
> J wrote:
>> Hello. We have some .asp pages running on our W2K Server machine that
>> calls
>> and runs some stored procedures that's on our other W2K Server SQL Server
>> 2000 machine. We are using https for these web .asp pages and was
>> wondering
>> if there was any way to speed up the process of the .asp pages outputting
>> the stored procedures results? I have indexes on the main fields in the
>> base tables that the stored procedures run. It takes like a minute or so
>> for the data to display on the .asp pages but have a user asking if
>> there's
>> a way to speed up the process?
>>
>> Thanks in advance.
>
> Use QA to test the stored procs to eliminate them as the possible cause
> of the delay. If they take a while to execute, try a sql server
> programming group for advice on how to rewrite them more efficiently.
> Https will always slow things a bit. Does this page really need it?
>
> If the stored procs are fine, and https is required, you will have to
> look at the code you are using to output the results. Here's a link to
> efficient methods of outputting recordsets:
>
> http://databases.aspfaq.com/database/how-do-i-page-through-a -recordset.html
>
> --
> Mike Brind
>