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?

Turn to “Database” section by clicking on related header icon. Then click “Partitions” tab

This section displays all the partitions available in the Project. To generate a new partition, click “New” button

A popup is displayed and you 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 DB.

Recap

In this document, 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.