Question: Does Python do extremely too many GCs for ORMs?
YES, OMG YES. Check this out
Python Default GC Settings:
-
SQLAlchemy - 20,000 records in one query
- 1,859 GCs
- 908ms
- 78.7 MB mem
-
MongoDB - 20,000 records in one query
- 463 GCs
- 593ms
- 75.8 MB mem
Talk Python-optimized GC Settings:
- SQLAlchemy - 20,000 records in one query:
- 29 GCs (64x improvement)
- 695ms (23% improvement)
- 76.8 MB mem (surprisingly: 2% improvement with less GC)
- MongoDB - 20,000 records in one query
- 10 GCs (46x improvement)
- 515ms (13%)
- 72.3 MB mem (surprisingly: 4% improvement with less GC)