How to take load off a transactional database

0 like 0 dislike
asked Jan 5 in Data Integration by Salim
edited Mar 7 by admin
How to take load off a transactional database.

1 Answer

0 like 0 dislike
answered Jan 8 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.