How should we deal with multiple transaction-report requests?

Posted by Mithir on Programmers See other posts from Programmers or by Mithir
Published on 2011-11-20T10:20:43Z Indexed on 2011/11/20 18:25 UTC
Read the original article Hit count: 265

We are developing a system for the retail market which one of it's features will enable clients(actually consumer clubs) to go through all transactions made by end-clients.

One of the ways to get this information will be via an API.

The idea is that there will be requests for reports with a start date and an end date, and a response will have all the transactions between those dates.

We are worry that some reports may be very large, and that some clients will repeatedly request for reports, in this case the DB and CPU will be very overloaded.

The same server that will service those requests, also takes care the the actual retail transactions (received by proprietary devices) and a Web application.

We are not sure about how to limit the report requests from the API so that it won't affect the system too much.

So, how should we deal with this scenario? any thoughts?

EDIT:

just to make clear: When I mentioned proprietary devices I meant "On-Location" devices which are used during sales with end-clients, this means that these requests shouldn't get delayed, and this is the main concern.

© Programmers or respective owner

Related posts about database

Related posts about Performance