php - How to handle concurrent DB connections by multiple users using PDO in PHP5 -
i want use pdo in application. confused regarding use of pdo here. because application access target multiple users. lets 100 users in simultaneously . so, read pdo create 100 db connections access. can create problem limit on concurrent connections allowed server. , new users connection error.
how can use pdo such way handles concurrent connections , not overhead?
100 concurrent users not impressive number though. taken average user makes click once minute, have 100 connects 60 seconds, makes 1.5 connects / second.
sanely written app should perform no longer 0,1 sec. means 10 connections fit in 1 second. , have 1.5.
yes, can peak sometimes, anyway, number of allowed connections last thing think of. database killed far earlier limit reached - due improper indexing , architecture.
Comments
Post a Comment