Vladyslav Dalechyn
@dalechyn.eth
Finally after 4 days of non stop work I can rest for a bit - optimized database for @launchtokenbot as it before could not handle the traffic. Most of the queries take milliseconds to execute now. My lesson learned - you can index lots of dex events but most likely itโs not worth it and youโll end up in unoptimizable SYNC exec plan pit-hole. Good thing is that I understand postgresql much better now.
1 reply
6 recasts
39 reactions
Kien ๐
@kienfam
Thank you ๐
0 reply
0 recast
2 reactions