How to prevent my system from impacting database performance?

I'm designing a service which could potentially retrieve large amounts of data from my database. This service runs very infrequently, maybe once a week. Given that many other services are using this database, how can I prevent my new service from impacting the database's performance with my queries such that the other services' performance isn't impacted as a result?

I've considered a very basic rate limiting approach, where my service only makes queries to the database between certain time intervals in batches, but I wanted to know of any other things that might be helpful.

submitted by /u/Forumpy
[link] [comments]

from Software Development – methodologies, techniques, and tools. Covering Agile, RUP, Waterfall + more! https://ift.tt/YyIGQ0O

Leave a comment

Design a site like this with WordPress.com
Get started
search previous next tag category expand menu location phone mail time cart zoom edit close