(0079812)
|
mtaal
|
2015-08-30 06:58
|
|
Current status: support 900 concurrent logins
There are some opportunities to check further by using apache connection pool, see snippet of email below. But for current projects it is not needed to support more as large stores can have their own store server to balance the load on login.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Hi Martin,
This is where 1000 concurrent user login test was left out in the middle of July:
T9 results https://docs.google.com/document/d/15KyTV2thUk4oVFcQSaqsfJv6THbMzyUW9yU7hCEVGNk/edit [^]
Test scenarios https://docs.google.com/spreadsheets/d/1VTVsTeQn3d4Mb11TnfZLhexMYsPT-wNTX9ukypbWN1I/edit#gid=2002035676 [^]
In the meantime, from July to nowadays, , it seems now Openbravo is able to use Apache Tomcat pool style implementation to improve the database performance for high concurrent environments. So, It seems, I was not totally wrong in my previous e-mail, demanding some pool features there were not ready yet.
So I guess it makes sense to check 1000 concurrent logins with this new implementation (see bellow)
http://wiki.openbravo.com/wiki/Modules:Apache_JDBC_Connection_Pool [^]
Openbravo provides a free commercial module that implements the Tomcat JDBC Connection Pool.
Starting from 3.0PR15Q4 Apache JDBC Connection Pool module is included within Openbravo 3.0 distribution
It merges the current two connection pools (Hibernate default connection pool for DAL-related queries + Apache DBCP for the connections provided by the ConnectionProviderImpl.) into one logical pool.
It provides advanced pool capabilities that if properly configured will improve the database performance for high concurrent environments.
It allows the addition of custom interceptors that can be used to enhance the functionality in several ways (Add database monitoring, Retry queries, Cache query results, ..)
More links:
http://centralrepository.openbravo.com/openbravo/org.openbravo.forge.ui/ForgeModuleDetail/Apache-External-Connection-Pool [^]
http://wiki.openbravo.com/wiki/Projects:Inclusion_Of_Apache_JDBC_Connection_Pool_In_Distribution [^]
http://people.apache.org/~fhanik/jdbc-pool/jdbc-pool.html [^] |
|