• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 149
  • Last Modified:

postgres queries -- need opinions

Generally speaking, it is better to make lots of frequent queries on a db (that pull a small amount of data), or less frequent queries on the db (that pull a large amount of data).   I don't want to overload anything, or lock anyone out...  I am not an expert by any means with databases, so, for my benefit, please keep discussion at a high level.  Thanks!!
1 Solution
Pawan KumarDatabase ExpertCommented:
If your queries fetching small amount of data then it is good but sometimes we have fetch large data also depending on the requirement.

The whole idea should be like the queries should take optimal time to return that data. and the health of the Db should be good.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now