Re: Oracle ODBC scalability with increased user volumes


<strepxe@xxxxxxxxxxx> wrote in message
news:c107326d-54d2-4bf7-abe2-e8d49b0fbbae@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

We have an application that uses ODBC to connect our client
application to an Oracle database. Currently we run at approximately
10-100 concurrent users with no major problem. A request has come in
asking if the application would be able to support approximately 1000
concurrent users. My feeling on this is that the number of concurrent
users could adversely affect performance and some pooling technology/
architectural change would be needed. What I lack is any guidelines on
the limitations of ODBC in this regard. Can anyone point me in the
right direction?

Ger
The answer is really more complex. We don't know how well written your
application is or is not. Using ODBC doesn't mean it is well written or
not. (it could be either) If you do not use bind variables then there is
little chance your appliaction will scale. In short insufficient
information. Basically, with 1,000 users you will bottleneck somewhere, how
large is that bottleneck and what is it. If you don't use bind variables
buying more CPU (pr faster CPU) or memory won't do bupkis to solve the
problem. If you are IO bound then adding more CPU won't help. (It may
actually hurt; each query will get in line for the disk faster.)
Jim


.

Relevant Pages

  • Re: ACID et al
    ... another one is that i think it's a fallacy to imagine that one can write an app for concurrent users, let alone concurrent transactions without thinking through how their different purposes might clash, no matter how well the db engine in question is marketed! ...
    (comp.databases.theory)
  • Re: convincing a client to go with dotNet instead of Access project
    ... > Do you have reference for the performance threshold of 6 concurrent ... other connections, the performance started to decrease, almost ... Sorry about that, I'm doing java/jdbc dev ... find was articles talking about a limit of 255 concurrent users. ...
    (microsoft.public.dotnet.general)
  • Oracle ODBC scalability with increased user volumes
    ... We have an application that uses ODBC to connect our client ... application to an Oracle database. ... 10-100 concurrent users with no major problem. ...
    (comp.databases.oracle.server)
  • Re: My Web Application Support 1 Million concurrent user??
    ... Will you need database access, external systems, legacy systems? ... million concurrent requests is quite enormous. ... you'll be looking at more than 20 million concurrent users at least. ...
    (microsoft.public.dotnet.general)