Vladyslav Dalechyn pfp
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
18 reactions

Luicy.Eth pfp
Luicy.Eth
@luicy
GM sir
0 reply
0 recast
0 reaction