Hi everyone,



I'm running this ASP web application in VBScript on an IIS5 server. The

application talks via an ODBC connection to an Ingres database when

selecting or updating records.



It seems to work fine when there are 5 or less concurrent users on the

system, but if more than 5 users get on the system, the amount of script

timeouts occur exponentially. What happens is, when every user ( > 5) clicks

the submit button, the pages just keep waiting and waiting for the quires to

run and then finally time out.



What could be the cause of this? Can someone please help? I'm really

desperate here!!!



Many thanks in advance!



Sivas

Hi Sivas



I run into this type of situation with Oracle database & PeopleSoft.  To

avoid the time-out problem, my recommendation is this:



1) use the ado less connection, many time faster when thousands of row to

deal with

2) MAke sure the Ingres connection driver from the web server to the Ingres

DB server is current

3) Try the Microsoft driver

4) Try not to use too many join and outter-join.

5) We might want to create a new table from the Ingres DB side to house data

that has too many layer to locate.



Good luck!



Philip

----- Original Message -----

From: "Sivaskanthan, Sothilingam" <S.Sivaskanthan@m...>

To: "ASP Databases" <asp_databases@p...>

Sent: Tuesday, November 27, 2001 2:32 PM

Subject: [asp_databases] ASP to Ingres: Script timeout





> Hi everyone,

>

> I'm running this ASP web application in VBScript on an IIS5 server. The

> application talks via an ODBC connection to an Ingres database when

> selecting or updating records.

>

> It seems to work fine when there are 5 or less concurrent users on the

> system, but if more than 5 users get on the system, the amount of script

> timeouts occur exponentially. What happens is, when every user ( > 5)

clicks

> the submit button, the pages just keep waiting and waiting for the quires

to

> run and then finally time out.

>

> What could be the cause of this? Can someone please help? I'm really

> desperate here!!!

>

> Many thanks in advance!

>

> Sivas

>

>




$subst('Email.Unsub')

>

> Read the future with ebooks at B&N

>

http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&categoryid

=rn_ebooks

>