3 ms·
On "it's slow" ... 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 wa
by dblock 15y ago
On "it's slow" ...
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.
- lukeholder 15y agoI posted a question on stackoverflow trying to gather pros and cons of the methods outlined in this HN post. http://stackoverflow.com/questions/8022715/standalone-rails-application-per-model-service http://stackoverflow.com/questions/8022715/standalone-rails-...