Subversion Repositories SmartDukaan

Rev

Show changed files | Directory listing | RSS feed

Filtering Options

Rev Age Author Path Log message Diff
35718 93 d 1 h amit /trunk/PyProj/src/shop2020/ fix: use session.remove() instead of session.close() to prevent memory leaks in all services  
35701 93 d 9 h amit /trunk/PyProj/src/ Performance fix: reduce logging level to WARNING, remove incompatible pool_pre_ping, fix tornado dependency

- Changed logging.basicConfig from DEBUG to WARNING in 6 service files to stop
SQLAlchemy query spam that caused memory bloat (TransactionServer 553MB -> 63MB)
- Set echoOn=False as default in PurchaseServiceHandler
- Removed pool_pre_ping=True from 7 DataService files (incompatible with SQLAlchemy 0.6.6)
- Updated tornado dependency from 1.0.1 to 1.0 in setup.py (1.0.1 unavailable on PyPI)
 
35608 105 d 9 h amit /trunk/PyProj/src/shop2020/ Fix DB connection pooling to reduce service restarts

- Add pool_timeout=30 to fail fast instead of hanging indefinitely
- Add pool_pre_ping=True to detect stale MySQL connections before use
- Reduce pool_recycle from 7200s to 3600s for fresher connections
- Disable SQL echo logging (echo=False) to reduce memory/CPU usage
- Fix MongoDB connection with thread-safe initialization and proper pooling

Modified services: helper, user, inventory, order, payment, logistics, catalog
 
2747 5403 d 13 h chandranshu /trunk/ Added the missing links to create a refund  
2309 5439 d 10 h ankur.singhal /trunk/PyProj/src/shop2020/payments/impl/ bug fixed in to_t_payment_gateway  
2192 5447 d 8 h chandranshu /trunk/PyProj/src/shop2020/payments/impl/ Closed the session after querying for statistics.  
2062 5459 d 7 h ankur.singhal /trunk/PyProj/src/shop2020/ change method getPayments comments. If gatewayId is passed as 0, it is ignored.  
1731 5487 d 9 h ankur.singhal /trunk/ optimisation of methods for getting max, min amounts of orders and payments. These methods are used for statistics (Support).  
1659 5489 d 12 h chandranshu /trunk/PyProj/src/shop2020/payments/impl/ Payment status was not getting set to INIT since the attribute used there was named ps  
1657 5489 d 13 h ankur.singhal /trunk/PyProj/src/shop2020/payments/impl/ modified max and min payment amount calls to return the amounts of only successful payments.  
1627 5490 d 14 h ankur.singhal /trunk/PyProj/src/shop2020/ added methods in PaymentsHandler and OrderServiceHandler for getting statistics. (max & min order amount, max & min payment amount, distinct customers who have bought)  
1493 5501 d 9 h vikas /trunk/PyProj/src/shop2020/ Return all transactions/payments when status passed is None.  
1415 5507 d 6 h chandranshu /trunk/PyProj/src/shop2020/ Added dbname parameter to all the servers  
1267 5517 d 10 h chandranshu /trunk/PyProj/src/shop2020/ Started reading dbname parameters from the config file  
1248 5518 d 13 h chandranshu /trunk/PyProj/src/shop2020/ Made database name a configurable parameter for Payment, Logistics and Helper service to ensure that test and development databases can be different  
1131 5529 d 8 h chandranshu /trunk/PyProj/src/shop2020/ Added pool_recycle parameter to the create_engine call  
1130 5529 d 8 h rajveer /trunk/PyProj/src/shop2020/payments/impl/ modified size of the description column to 200  
1129 5529 d 8 h rajveer /trunk/PyProj/src/shop2020/payments/impl/ fixed payment argument  
1120 5529 d 10 h rajveer /trunk/PyProj/src/shop2020/ Added gatewayTxnDate in update payment method. Updated code to update timestamp. Updated code to return zero count if there are no items  
859 5557 d 13 h chandranshu /trunk/PyProj/src/shop2020/payments/impl/ Corrected a typo  

Show All