Unfortunately the answer is "from experience." Everything comes with trade offs and knowing when to use subqueries versus temp tables is more around the context of the problem and the experience of doing things the wrong way.
I'd recommend toy problems or building little tools in a dev env to get that kind of experience.
David
npub1mcn…wtll
2023-09-27 01:07:29
in reply to nevent1q…rkqs
Author Public Key
npub1mcneaunh0n9qy54sse0vr06nwhejzghumfjlmu3r54ugwx83qhlshqwtllPublished at
2023-09-27 01:07:29Event JSON
{
"id": "0812472883643c7947df7ce8d2240bdcb0d7bee4ab0d79d7d0f2fe2fccb6ed8a",
"pubkey": "de279ef2777cca0252b0865ec1bf5375f32122fcda65fdf223a5788718f105ff",
"created_at": 1695769649,
"kind": 1,
"tags": [
[
"e",
"58794ca3518684709579863befb80c090a7d03a4bffc91133dc1f59e20250832",
"",
"root"
],
[
"e",
"3deb9a64988405eec64559674301493abf9457132e05303710b06b7408efb16f"
],
[
"e",
"aac6b21624b249aa2432c8028e8297e43eff401e638e6564448ccf2730739859",
"",
"reply"
],
[
"p",
"de279ef2777cca0252b0865ec1bf5375f32122fcda65fdf223a5788718f105ff"
],
[
"p",
"92d9ef27dd2c02793aa9d5740a20f2bfda8020b08ad50d0ef283ed08d5c2e224"
]
],
"content": "Unfortunately the answer is \"from experience.\" Everything comes with trade offs and knowing when to use subqueries versus temp tables is more around the context of the problem and the experience of doing things the wrong way.\n\nI'd recommend toy problems or building little tools in a dev env to get that kind of experience.",
"sig": "125a1434b2568b66f4c904576a5883db5b089c26c205e34379470e800b399ba9d38484f66821ea5014dc7813a4adad60cc4f04f98cd30621a2404e36d2b7dd53"
}