Subversion Repositories SmartDukaan

Rev

Show changed files | Directory listing | RSS feed

Filtering Options

Rev Age Author Path Log message Diff
35751 68 d 0 h amit /trunk/PyProj/src/shop2020/model/v1/order/impl/ TransactionServer: add session.expunge_all() and periodic gc.collect() in close_session() to prevent memory growth from ORM identity map accumulation and Python 2.7 memory fragmentation  
35738 68 d 22 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  
35734 68 d 23 h amit /trunk/PyProj/src/shop2020/model/v1/order/impl/ Remove AlertClient dependency from order DataAccessors and ObsoleteDataAccessors  
35732 68 d 23 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 70 d 14 h amit /trunk/PyProj/src/shop2020/ fix: use session.remove() instead of session.close() to prevent memory leaks in all services  
35701 70 d 21 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 82 d 21 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		  
34206 427 d 23 h amit.gupta /trunk/PyProj/src/shop2020/model/v1/order/impl/ Added comment  
34205 427 d 23 h amit.gupta /trunk/PyProj/src/shop2020/model/v1/order/impl/ Removed change color  
31115 1269 d 15 h amit.gupta /trunk/PyProj/src/shop2020/model/v1/inventory/impl/  
31015 1291 d 21 h amit.gupta /trunk/PyProj/src/shop2020/model/v1/inventory/impl/  
30569 1418 d 23 h amit.gupta /trunk/PyProj/src/shop2020/model/v1/user/impl/  
30063 1521 d 18 h amit.gupta /trunk/PyProj/src/shop2020/model/v1/order/impl/  
28647 1736 d 23 h amit.gupta /trunk/PyProj/src/shop2020/model/v1/inventory/impl/ Added expunge  
28630 1740 d 1 h amit.gupta /trunk/PyProj/src/shop2020/model/v1/inventory/impl/  
28629 1740 d 1 h amit.gupta /trunk/PyProj/src/shop2020/model/v1/inventory/impl/  
28628 1740 d 1 h amit.gupta /trunk/PyProj/src/shop2020/model/v1/inventory/impl/  
28621 1741 d 20 h amit.gupta /trunk/PyProj/src/shop2020/model/v1/inventory/impl/  
28620 1741 d 23 h amit.gupta /trunk/PyProj/src/shop2020/model/v1/inventory/impl/ Done changes related to Warehouse issue  
28554 1748 d 21 h amit.gupta /trunk/PyProj/src/shop2020/model/v1/inventory/impl/  

←Prev12Next→

Show All