ASP DB Performance

[Mark Sherwood]

On a web site that is using ASP-DB in 3 tiers for IIS 4, MTS and SQL 7 all on the NT4 operating system.

When the first connection to the web site that uses the ASP-DB MTS component it takes about 30 seconds then when this user uses the same component for a different search it only takes about 3 seconds.

When another user then makes an initial request to the web site it takes
about 10 seconds for the initial request and then about 3 seconds for any
subsequent requests.

Is there a method of finding which of the tiers is taken the most time and
how to reduce this time?

[Frank Kwong]

Try seting up the component activation type as "library application" and try again.

FK


------------
Mark Sherwood at 3/29/01 9:36:36 AM

On a web site that is using ASP-DB in 3 tiers for IIS 4, MTS and SQL 7 all on the NT4 operating system.

When the first connection to the web site that uses the ASP-DB MTS component it takes about 30 seconds then when this user uses the same component for a different search it only takes about 3 seconds.

When another user then makes an initial request to the web site it takes
about 10 seconds for the initial request and then about 3 seconds for any
subsequent requests.

Is there a method of finding which of the tiers is taken the most time and
how to reduce this time?