Chapter 8. Using a Separate Reporting Database
By now you’ve probably noticed that we sometimes jump through significant hoops to query the data we want for reporting purposes. Running reporting queries from your main application against your production (transactional) database can potentially take away from valuable resources. Imagine a report that takes more than a couple of seconds to run with an impatient user on the other side. Click. Click. Click. Before you know it you’ve tied up all available connections to the database and cannot conduct business until the connections clear.
Transactional versus Reporting Databases
What do I mean by “transactional” and why differentiate?
Simply put, your application exists to conduct transactions. ...
Get Data Visualization Toolkit: Using JavaScript, Rails™, and Postgres to Present Data and Geospatial Information now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
