Improving OLTP and OLAP performance 3/3: ETL and column-oriented DBMS
In this video, Alejandro Duarte shows how to use MariaDB's ColumnStore engine to improve the performance of analytical queries in Vaadin Flow applications.
0:00 Intro
0:27 The example application
1:30 Adding a native query to the repository
5:31 Adding a view (Vaadin flow)
7:09 Testing the slow behavior
8:40 Using ColumnStore
11:52 Testing the improvement
12:53 Outro
Links:
Follow Alejandro on Twitter: / alejandro_du
The example application from scratch: • Easy test data generation for Java ap...
Part 1 (lazy loading): • Improving OLTP and OLAP part 1 of 3: ...
Part 2 (fast filtering): • Improving OLTP and OLAP performance 2...
Source code: https://github.com/alejandro-du/vaadi...
Create a new Vaadin project: https://start.vaadin.com
More about Vaadin Flow (Java): https://vaadin.com/flow
