Subversion Repositories SmartDukaan

Rev

Show changed files | Directory listing | RSS feed

Filtering Options

Rev Age Author Path Log message Diff
35751 69 d 15 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 70 d 12 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 70 d 13 h amit /trunk/PyProj/src/shop2020/model/v1/order/impl/ Remove AlertClient dependency from order DataAccessors and ObsoleteDataAccessors  
35732 70 d 13 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  
35722 71 d 16 h amit /trunk/PyProj/src/shop2020/logistics/service/impl/ perf: use raw SQL for logistics startup caches to avoid ORM memory overhead  
35718 72 d 4 h amit /trunk/PyProj/src/shop2020/ fix: use session.remove() instead of session.close() to prevent memory leaks in all services  
35701 72 d 11 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 84 d 11 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 429 d 13 h amit.gupta /trunk/PyProj/src/shop2020/model/v1/order/impl/ Added comment  
34205 429 d 13 h amit.gupta /trunk/PyProj/src/shop2020/model/v1/order/impl/ Removed change color  
33491 665 d 10 h amit.gupta /trunk/PyProj/src/shop2020/config/resources/ Added new db  
31115 1271 d 6 h amit.gupta /trunk/PyProj/src/shop2020/model/v1/inventory/impl/  
31041 1288 d 11 h amit.gupta /trunk/PyProj/src/shop2020/logistics/service/impl/  
31015 1293 d 11 h amit.gupta /trunk/PyProj/src/shop2020/model/v1/inventory/impl/  
30569 1420 d 13 h amit.gupta /trunk/PyProj/src/shop2020/model/v1/user/impl/  
30540 1422 d 13 h amit.gupta /trunk/PyProj/src/shop2020/config/resources/  
30536 1423 d 9 h amit.gupta /trunk/PyProj/src/shop2020/config/resources/  
30528 1423 d 14 h amit.gupta /trunk/PyProj/src/shop2020/config/resources/  
30520 1425 d 10 h amit.gupta /trunk/PyProj/src/shop2020/config/resources/  
30515 1426 d 17 h amit.gupta /trunk/PyProj/src/shop2020/config/resources/  

←Prev12Next→

Show All