1 points | by radimm 10 hours ago ago
2 comments
Somehow it feel HOT updates are very confusing. You can also try to play with interactive visualizer to understand it better https://boringsql.com/visualizers/hot-updates/
I didn't get HOT until I saw a visualizer. My mistake was updating an indexed column and wondering why nothing got faster.
Somehow it feel HOT updates are very confusing. You can also try to play with interactive visualizer to understand it better https://boringsql.com/visualizers/hot-updates/
I didn't get HOT until I saw a visualizer. My mistake was updating an indexed column and wondering why nothing got faster.