Thanh Hà 🎩🎭
@thanhha
It’s not rocket science to build fast indexing. Use Postgres COPY (binary). 1M events: COPY 30-80s, bulk INSERT 7.5-15min, standard INSERTs 15-30h. Disable constraints/indexes for speed. COPY 60-100x faster than bulk, 1800-3600x vs standard. There is no second best. Process multiple log results concurrently for the fastest results. Ofc if using RPC requests to get the data use a paid / high rate limit RPC node.
1 reply
0 recast
0 reaction
Hồng Phượng 🎭
@hongphuong
Ủa j z tr! 2 👏 Nếu có thêm thông tin gì, bồ hãy chia sẻ nhé!
0 reply
0 recast
0 reaction