Subversion Repositories SmartDukaan

Rev

Show changed files | Directory listing | RSS feed

Filtering Options

Rev Age Author Path Log message Diff
35722 71 d 18 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 6 h amit /trunk/PyProj/src/shop2020/ fix: use session.remove() instead of session.close() to prevent memory leaks in all services  
35701 72 d 14 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 13 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
 
31041 1288 d 13 h amit.gupta /trunk/PyProj/src/shop2020/logistics/service/impl/  
23839 2850 d 19 h amit.gupta /trunk/ changed mail domain profitmandi.com -> smartdukaan.com  
23713 2887 d 14 h amit.gupta /trunk/PyProj/src/shop2020/logistics/service/impl/ Fixed pincode  
23712 2887 d 14 h amit.gupta /trunk/PyProj/src/shop2020/logistics/service/impl/  
23711 2887 d 15 h amit.gupta /trunk/PyProj/src/shop2020/logistics/service/impl/  
23686 2891 d 13 h amit.gupta /trunk/PyProj/src/shop2020/ Fixed order creation for courier  
23451 2956 d 8 h amit.gupta /trunk/PyProj/src/shop2020/logistics/service/impl/  
23449 2956 d 8 h amit.gupta /trunk/PyProj/src/shop2020/logistics/service/impl/  
23447 2956 d 10 h amit.gupta /trunk/PyProj/src/shop2020/logistics/service/impl/  
23446 2956 d 10 h amit.gupta /trunk/ Added changes related to fofo.  
23316 3000 d 18 h amit.gupta /trunk/PyProj/src/shop2020/ Fixed old bugs  
23302 3003 d 13 h amit.gupta /trunk/PyProj/src/shop2020/logistics/service/impl/  
23237 3016 d 16 h amit.gupta /trunk/PyProj/src/shop2020/logistics/service/impl/  
23234 3016 d 16 h amit.gupta /trunk/PyProj/src/shop2020/logistics/service/impl/  
23233 3016 d 16 h amit.gupta /trunk/PyProj/src/shop2020/logistics/service/impl/  
23232 3016 d 17 h amit.gupta /trunk/PyProj/src/shop2020/logistics/service/impl/  

Show All