2022-08-24-TIL

Today I Learned

Instagram Architecture

  • https://www.educative.io/courses/grokking-the-system-design-interview/m2yDVZnQ8lG
  • https://instagram-engineering.com/search-architecture-eeb34a936d3a

New Features in Java 17

  • https://www.baeldung.com/java-17-new-features
  • https://mkyong.com/java/what-is-new-in-java-17/

JPA N+1 Query Problem

  • https://medium.com/geekculture/jpa-entitygraphs-a-solution-to-n-1-query-problem-e29c28abe5fb#:~:text=The%20N%2B1%20query%20problem%20is%20said%20to%20occur%20when,the%20performance%20of%20the%20application.
  • https://stackoverflow.com/questions/97197/what-is-the-n1-selects-problem-in-orm-object-relational-mapping#:~:text=The%20N%2B1%20query%20problem%20happens%20when%20the%20data%20access,the%20larger%20the%20performance%20impact.
  • https://medium.com/doctolib/understanding-and-fixing-n-1-query-30623109fe89
  • https://zetawiki.com/wiki/N%2B1%EC%BF%BC%EB%A6%AC%EB%AC%B8%EC%A0%9C
  • https://velog.io/@jinyoungchoi95/JPA-%EB%AA%A8%EB%93%A0-N1-%EB%B0%9C%EC%83%9D-%EC%BC%80%EC%9D%B4%EC%8A%A4%EA%B3%BC-%ED%95%B4%EA%B2%B0%EC%B1%85
  • https://ict-nroo.tistory.com/132

Index와 성능

  • https://ddotle99.tistory.com/3
  • https://jojoldu.tistory.com/243
  • https://tecoble.techcourse.co.kr/post/2021-09-18-db-index/
  • https://dataonair.or.kr/db-tech-reference/d-story/data-story/?mod=document&uid=63127

Boolean Index

  • https://stackoverflow.com/questions/10524651/is-there-any-performance-gain-in-indexing-a-boolean-field

하나의 Controller, 여러개의 Thread

  • https://jeong-pro.tistory.com/204

JVM

  • https://velog.io/@litien/JVM-%EA%B5%AC%EC%A1%B0
  • https://spring.io/blog/2019/03/11/memory-footprint-of-the-jvm#:~:text=The%20JVM%20divides%20its%20memory,referenced%20and%20are%20garbage%20collected.

추상클래스 vs 인터페이스

  • https://brunch.co.kr/@kd4/6