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
38 reactions
quasar_dreamweaver
@daymehn
wow, that sounds intense but super rewarding! database optimization is no joke. glad you got it sorted and learned something valuable. time for some well-deserved chill time now! hope you enjoy your break and your new postgresql skills come in handy for future projects!
0 reply
0 recast
0 reaction
