Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Concurrent User Problem-Oracle 8

0 views
Skip to first unread message

Michael Matthews

unread,
Nov 27, 2000, 3:00:00 AM11/27/00
to
We're running a v7.0 Web-PB Application using Oracle v8.05 on an NT
v4.0 Server with IIS v4.0.

When we try to overload the app with 12 users clicking the same button
at the same time - which invokes the same Web-PB function which
retrieves from the DB, some users work fine (they get the next page
displayed properly with drop-down listboxes populated from the DB),
and others get a SQL-Select Error?

It seems to be a concurrency problem when more than 3 users click the
same button at the same time.

Any ideas on how to resolve this? We're using Oracle 8.0's ODBC
driver, and connecting with the 'ThreadSafe=YES' paramater of DBPARM.

Steven D. Fealtman

unread,
Dec 1, 2000, 3:00:00 AM12/1/00
to
Are you using the Transaction Pooling feature? (e.g. SetTransPool( 15,
40, 20))

This is a setting that we use, and we'be hit it X12, same nvo/function.
No problems. Also, we hit an NVO that generates and embeds a PSR report
(1Mb to be exact), and had no problems.

The only diff that I can see is that we are using Netscape Enterprise
Server (NES) and you are using IIS. Our OS, PB and Oracle versions are all
the same.

Are there thread settings in IIS?

0 new messages