Results 1 to 2 of 2

Thread: ASP DB Performance

  1. #1
    Mark Sherwood Guest

    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?


  2. #2
    Frank Kwong Guest

    ASP DB Performance (reply)

    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?


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •