How can I efficiently retrieve settings from my database?

I am saving certain setting keys in my database using a model called "Settings," which has fields for "id," "server_id," "key," and "value." I often need to retrieve multiple settings at the same time, such as "applications enabled" and "applications channel." I think this method is not efficient, so I want to know if there are other ways to retrieve data from this table using Prisma that would be more efficient.
2 Replies
tropic
tropicOP2y ago
^ The picture attached is a list of all the settings that I currently have
Scot
Scot2y ago
What method are you using atm? If you have an index on those keys pretty much any method is fine And with that little rows even a full table scan isn’t bad
Want results from more Discord servers?
Add your server