Database Partitions
- Sergio Rodriguez
- Matias
Overview
Partitioning is the database process where very large tables are divided into multiple smaller parts. Main goal of this action is to assist in maintenance of large tables and to reduce the overall response time to read and load data for particular SQL operations.
How to create a Partition in Wayfast?
As precondition, make sure you have an “Active” requirement in Wayfast before starting this process.
Turn to “Database” section by clicking on icon at the top menu. Then click on “Partitions” tab
This section displays all the partitions available in the Project. Click on “New” button to generate a new partition.
A popup is displayed and we can choose in “Table” lookup field what is the table that needs to be partitioned to improve the performance in the application. Once the table is selected, “Column” lookup will retrieve all the columns available in the table previously picked.
Partitioning column is usually a datetime column but all data types that are valid for use as index columns can be used as a partitioning column, except a timestamp column
To finalize the partition, make sure that the “With Schema” and “Active” checkboxes are checked to generate automatically the partition in Wayfast and your database in synchronization.
Recap
In this lesson, we learnt how to split a large table into smaller, individual tables. Queries that access only a fraction of the data can run faster because there is less data to scan, this functionality will improve the performance in your application.