Super Duper SQL Tips for Software Engineersby@deft
920 reads
920 reads

Super Duper SQL Tips for Software Engineers

by Sergey Golitsyn7mJuly 19th, 2022
Read on Terminal Reader
Read this story w/o Javascript
tldt arrow

Too Long; Didn't Read

In this post, we will talk about how you can possibly improve your database queries and speed up your applications. Everything is collected based on my experience and parts found on the Internet. The primary query that can be used: select sum(1) from table_name:::float/(select sum() from table #:: select sum(one) from #:. Select sum() is a more constructive option than determining by eye or sitting with a stopwatch. The lower the value of the second column, the more likely it is that the index will be justified.

Companies Mentioned

Mention Thumbnail
Mention Thumbnail
featured image - Super Duper SQL Tips for Software Engineers
Sergey Golitsyn HackerNoon profile picture
Sergey Golitsyn

Sergey Golitsyn

@deft

Senior Software Engineer with 7+ YoE building massively scalable systems both from scratch and diving into a codebase

About @deft
LEARN MORE ABOUT @DEFT'S
EXPERTISE AND PLACE ON THE INTERNET.

Share Your Thoughts

About Author

Sergey Golitsyn HackerNoon profile picture
Sergey Golitsyn@deft
Senior Software Engineer with 7+ YoE building massively scalable systems both from scratch and diving into a codebase

TOPICS

THIS ARTICLE WAS FEATURED IN...

Permanent on Arweave
Read on Terminal Reader
Read this story in a terminal
 Terminal
Read this story w/o Javascript
Read this story w/o Javascript
 Lite
L O A D I N G
. . . comments & more!