Simple questions about modularity
Hi, I am re-structuring my code and I wanted to ask if it makes sense to put al lot off common prisma queries within function, e.g. in a simple getBalance function where I need the account data, I could make an accountService and make the code a bit cleaner in my eyes.
Does this makes sense, it's my first big project, and I want to do some best practices cause the code needs to be adaptable with the future in mind.
I would appreciate any quick feedback on this from someone more experienced!...
Memory leak on binary engine type
I think prisma binary type might have some emmory leak. I have been running my prisma app for over a year now and had memory leak but could not find reason. Yesterday removed binary engine type and it seems to fix the issue.
Wrong connection pool info ??
On production my queires stopped working with error
Timed out fetching a new connection from the connection pool. More info: http://pris.ly/d/connection-pool (Current connection pool timeout: 10, connection limit: 9)
but actually im on DigitalOcean with another configuration showed on picture....
How to solve this in Prisma, count related entries of complex query
Consider a filtering mechanism as suggested in the linked image. We would like to show the results count depending on each "attribute option". See the prisma schema and trpc route here: https://gist.github.com/riccardolardi/7ab7c9a7792ed9428298630c3b30f22c
This approach is evidently very inefficient since it introduces a classic n+1 problem, where we fetch the attributes for the selected category and then loop over each of them and again fetch the count for each attribute option.
I can't seem any other solution other than writing a raw SQL query for this kind of problem. Or am I missing something?...
