Does using prisma count query scale? I mean if user has a post relationship.. We know that user can have many post without limit in span of the user lifetime does this has drawback with performance??
Or will it be good if prisma auto handle this case incrementing decrementing post count if post was added or deleted regardless if batch create or delete