Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0029911 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| feature request | [Retail Modules] Web POS | major | have not tried | 2015-05-18 10:51 | 2015-08-30 07:02 | |||
| Reporter | mtaal | View Status | public | |||||
| Assigned To | mtaal | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | RR15Q4 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | mtaal | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0029911: WebPOS Login Technical Implementation Improvement | |||||||
| Description | Re-visit the current logic which is being run when a user logs in. Check if we can combine requests together to get to less requests, see if queries can be optimized. Create a jmeter test which can simulate many simulteneous logins to check resource consumption. | |||||||
| Steps To Reproduce | http://wiki.openbravo.com/wiki/Projects:Retail_Login_Process_Improvements [^] | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0079812) mtaal (manager) 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 [^] |
|
(0079813) mtaal (manager) 2015-08-30 06:58 |
See previous note |
|
(0079814) mtaal (manager) 2015-08-30 07:01 |
To accomplish high volume login support 2 things are important to note: - remote data preferences where enabled so product and business partners were not loaded at login - tests were done using jmeter In high volume environments it makes sense to install this module: https://code.openbravo.com/erp/pmods/org.openbravo.retail.highvolumesconfig/ [^] and check related indexes also |
|
(0079815) mtaal (manager) 2015-08-30 07:02 |
Tested |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2015-05-18 10:51 | mtaal | New Issue | |
| 2015-05-18 10:51 | mtaal | Assigned To | => mtaal |
| 2015-05-18 10:51 | mtaal | Triggers an Emergency Pack | => No |
| 2015-08-24 13:03 | mtaal | Relationship added | depends on 0030040 |
| 2015-08-30 06:56 | mtaal | Status | new => scheduled |
| 2015-08-30 06:58 | mtaal | Note Added: 0079812 | |
| 2015-08-30 06:58 | mtaal | Note Added: 0079813 | |
| 2015-08-30 06:58 | mtaal | Status | scheduled => resolved |
| 2015-08-30 06:58 | mtaal | Fixed in Version | => RR15Q4 |
| 2015-08-30 06:58 | mtaal | Resolution | open => fixed |
| 2015-08-30 07:01 | mtaal | Note Added: 0079814 | |
| 2015-08-30 07:02 | mtaal | Review Assigned To | => mtaal |
| 2015-08-30 07:02 | mtaal | Note Added: 0079815 | |
| 2015-08-30 07:02 | mtaal | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |