How to take load off a transactional database

0 votes

1 Answer

0 votes
answered by Pentaho Support Desk
• Regardless of the speed of your database, when its primary purpose is storing and processing transactional data, you do not want to put additional load on it.
• Analytical queries can tax a transactional database and slow it down, negatively impacting mission critical business operations. Bringing in a set of data to an in-memory space increases the speed of analytics without compromising the speed of critical operational business systems.
Welcome to Pentaho Support Desk, where you can ask questions and receive answers from Pentaho experts of Tenth Planet.