ASP DB Performance

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?

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?