Allow Entity partitioning
developer can partitioning  the entity depend on attribute to enhance the database performance

However there would be one improvement, table partition is very uncommon.

Best regards

Currently, creating entities in OutSystems involves defining tables with attributes such as data types, lengths, labels, descriptions, and the configuration of indexes. However, for applications that handle large volumes of data, a critical feature is missing: table partitioning.

I propose that OutSystems implements the option of table partitioning and subpartitioning directly in the entities, natively. Additionally, allowing the creation of global indexes or indexes within the partitions would be a natural extension of this feature.

Partitioning would enable OutSystems developers to divide entity data based on criteria like dates, regions, or any other relevant key, significantly improving application performance in large data scenarios. Subpartitioning would bring even more granularity for more complex scenarios, where greater control over the data is required.

Pros:

• Improved Performance: Applications with large data volumes would benefit from better query and data manipulation performance.
• Scalability: Facilitates application scalability as data is split into smaller, more manageable partitions.
• Data Organization: Improves data management by allowing logical separation by partitions, such as by dates, regions, etc.
• Global and Local Indexes: The ability to create global indexes or indexes within partitions would bring additional flexibility to query optimization.

Cons:

• Added Complexity: Developers might face a learning curve when dealing with partitioning and its rules.
• Configuration Overhead: While it brings performance benefits, setting up and maintaining partitions and indexes can be more labor-intensive.
• Database Dependency: The feature might depend on the support offered by the underlying database (SQL Server, Oracle, etc.), which could limit its use in certain environments.

Creating tables with partitioning has benefits when it comes to performance, especially when we have a large number of records in a table.