Re: How can I optimize joins or cache misses in SQL api?

2020-12-09 Thread Danny Chan
Hi, Marco Villalobos ~ It's nice to see that you choose the SQL API which is more concise and expressive. To answer some of your questions: > Q: Is there a way to control that? I don't want the N + 1 query problem. No, the SQL evaluate row by row, there maybe some optimizations internal that bu

How can I optimize joins or cache misses in SQL api?

2020-12-08 Thread Marco Villalobos
scenario: kafka stream enriched with tableS in postgresql Let's pretend that the postgres has an organizations, departments, and persons table, and we want to join the full name of the kafka table that has the person id. I also want to determine if the person id is missing. This requires a left