Discussions
Categories
- 382.5K All Categories
- 2.1K Data
- 212 Big Data Appliance
- 1.9K Data Science
- 448.4K Databases
- 221.1K General Database Discussions
- 3.7K Java and JavaScript in the Database
- 25 Multilingual Engine
- 540 MySQL Community Space
- 469 NoSQL Database
- 7.8K Oracle Database Express Edition (XE)
- 2.9K ORDS, SODA & JSON in the Database
- 499 SQLcl
- 3.9K SQL Developer Data Modeler
- 186.3K SQL & PL/SQL
- 21.1K SQL Developer
- 293.8K Development
- 7 Developer Projects
- 128 Programming Languages
- 290.5K Development Tools
- 96 DevOps
- 3K QA/Testing
- 645.6K Java
- 24 Java Learning Subscription
- 36.9K Database Connectivity
- 151 Java Community Process
- 104 Java 25
- 22.1K Java APIs
- 137.9K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 146 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 200 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 289 LiveLabs
- 36 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.8K Other Languages
- 2.3K Chinese
- 168 Deutsche Oracle Community
- 1.2K Español
- 1.9K Japanese
- 234 Portuguese
Maximum of concurrent users ?
Hi,
I'm thinking a building a public Apex app.
The number of concurrent users will be eventually high.
Very hard to estimate, but I would say around 1000 users at the same time.
Most users will only run one page with a card region (with scroll pagination) and the query will be tuned to be as efficient as possible.
Let's imagine that the query will be fast.
Can APEX handle such load ?
Is it only a matter of CPU & Memory ?
If yes, what is the maximum number of concurrent users that a simple APEX App can handle, per CPU ?
Is there any other sort of limitation ?
With Thanks & Regards
Best Answer
-
See the answer to your other question too.
APEX can scale however big you need it to be. It is part of the Oracle database, which, of course, is very scalable . Similarly, you can use load balancing on the web server side. I'm no expert there, but there is plenty info on the subject.
Having said that: 1000 users that hit the database every second, or 1000 users that hit the database every hour is a huge difference. It really depends on the use of your application.
Answers
-
See the answer to your other question too.
APEX can scale however big you need it to be. It is part of the Oracle database, which, of course, is very scalable . Similarly, you can use load balancing on the web server side. I'm no expert there, but there is plenty info on the subject.
Having said that: 1000 users that hit the database every second, or 1000 users that hit the database every hour is a huge difference. It really depends on the use of your application.
-
Hello Nic,
Another element to remember is that APEX doesn't consume a database connection until you refresh or submit a page. So you can have a million users looking at an APEX screen with no database connection.
Many large organizations are using APEX including Oracle for applications like AskTom, Oracle Store and many many many other examples. So don't worry about scaling, technology is there with load balancing for WebLogic and RAC for database, and probably other means that I don't know about.
So even a 1000 users submitting a page at the same time is not a problem as long as you have your web listener configured properly.
Hope this helps!
-
Thanks guys for your answers, that helps.
Concerning the hosting provider for such app, Oracle Cloud APEX Service seems to be a good choice, it seems to scale easily, but I can't image to not have access to my tables, packages etc... with SQL Developer.
SQL Developer Web is not yet workable...
-
You can easily connect SQLDeveloper desktop to your Oracle Cloud database, but that is not an APEX topic.
