Subversion Repositories SmartDukaan

Rev

Show changed files | Directory listing | RSS feed

Filtering Options

Rev Age Author Path Log message Diff
35738 72 d 7 h amit /trunk/PyProj/src/shop2020/model/v1/inventory/impl/ Add session.expunge_all() after commits in inventory cache update functions to prevent ORM object accumulation  
35732 72 d 8 h amit /trunk/PyProj/src/shop2020/model/v1/inventory/impl/ Replace Warehouse ORM queries with raw SQL cache in inventory DataAcessors - same approach as logistics fix  
35718 73 d 23 h amit /trunk/PyProj/src/shop2020/ fix: use session.remove() instead of session.close() to prevent memory leaks in all services  
35701 74 d 6 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 86 d 6 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		  
31115 1273 d 1 h amit.gupta /trunk/PyProj/src/shop2020/model/v1/inventory/impl/  
31015 1295 d 6 h amit.gupta /trunk/PyProj/src/shop2020/model/v1/inventory/impl/  
28647 1740 d 8 h amit.gupta /trunk/PyProj/src/shop2020/model/v1/inventory/impl/ Added expunge  
28630 1743 d 10 h amit.gupta /trunk/PyProj/src/shop2020/model/v1/inventory/impl/  
28629 1743 d 10 h amit.gupta /trunk/PyProj/src/shop2020/model/v1/inventory/impl/  
28628 1743 d 10 h amit.gupta /trunk/PyProj/src/shop2020/model/v1/inventory/impl/  
28621 1745 d 5 h amit.gupta /trunk/PyProj/src/shop2020/model/v1/inventory/impl/  
28620 1745 d 9 h amit.gupta /trunk/PyProj/src/shop2020/model/v1/inventory/impl/ Done changes related to Warehouse issue  
28554 1752 d 6 h amit.gupta /trunk/PyProj/src/shop2020/model/v1/inventory/impl/  
28553 1752 d 6 h amit.gupta /trunk/PyProj/src/shop2020/model/v1/inventory/impl/  
28178 1843 d 5 h amit.gupta /trunk/PyProj/src/shop2020/model/v1/inventory/impl/  
27448 1966 d 8 h amit.gupta /trunk/PyProj/src/shop2020/model/v1/inventory/impl/  
26911 2085 d 9 h amit.gupta /trunk/PyProj/src/shop2020/model/v1/inventory/impl/  
25481 2433 d 8 h amit.gupta /trunk/PyProj/src/shop2020/model/v1/inventory/impl/  
25480 2433 d 8 h amit.gupta /trunk/PyProj/src/shop2020/model/v1/inventory/impl/  

←Prev12Next→

Show All