Subversion Repositories SmartDukaan

Rev

Show changed files | Directory listing | RSS feed

Filtering Options

Rev Age Author Path Log message Diff
35751 16 d 19 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 17 d 16 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 17 d 17 h amit /trunk/PyProj/src/shop2020/model/v1/order/impl/ Remove AlertClient dependency from order DataAccessors and ObsoleteDataAccessors  
35732 17 d 17 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 18 d 21 h amit /trunk/PyProj/src/shop2020/logistics/service/impl/ perf: use raw SQL for logistics startup caches to avoid ORM memory overhead  
35718 19 d 8 h amit /trunk/PyProj/src/shop2020/ fix: use session.remove() instead of session.close() to prevent memory leaks in all services  
35705 19 d 14 h amit /trunk/PyProj/src/ Include resource files (cfg, xml, xls) in egg build via package_data  
35701 19 d 16 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 31 d 15 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 376 d 17 h amit.gupta /trunk/PyProj/src/shop2020/model/v1/order/impl/ Added comment  
34205 376 d 17 h amit.gupta /trunk/PyProj/src/shop2020/model/v1/order/impl/ Removed change color  
33491 612 d 14 h amit.gupta /trunk/PyProj/src/shop2020/config/resources/ Added new db  
31115 1218 d 10 h amit.gupta /trunk/PyProj/src/shop2020/model/v1/inventory/impl/  
31041 1235 d 15 h amit.gupta /trunk/PyProj/src/shop2020/logistics/service/impl/  
31015 1240 d 15 h amit.gupta /trunk/PyProj/src/shop2020/model/v1/inventory/impl/  
30569 1367 d 17 h amit.gupta /trunk/PyProj/src/shop2020/model/v1/user/impl/  
30540 1369 d 17 h amit.gupta /trunk/PyProj/src/shop2020/config/resources/  
30536 1370 d 13 h amit.gupta /trunk/PyProj/src/shop2020/config/resources/  
30528 1370 d 18 h amit.gupta /trunk/PyProj/src/shop2020/config/resources/  
30520 1372 d 14 h amit.gupta /trunk/PyProj/src/shop2020/config/resources/  

Show All