Making direct calls to the DB probably won't make it ten times faster. Reporting data should come from a pre-aggregated table (think data warehouse) so that you're not doing anything than an indexed SELECT.
So anything displayed to the user should become instant. You're never displaying a million records at once, max 20.
For reporting, build those on the server side using a different data interface to the DB - RESTful is not the right answer here.
Making direct calls to the DB probably won't make it ten times faster. Reporting data should come from a pre-aggregated table (think data warehouse) so that you're not doing anything than an indexed SELECT.
So anything displayed to the user should become instant. You're never displaying a million records at once, max 20.
For reporting, build those on the server side using a different data interface to the DB - RESTful is not the right answer here.