Overview

Sets all assocation from 'assocation table' to 'direct' for selected modules.

Documentation

Set Associations Direct

A Mendix Studio Pro web extension that converts association storage format from association table to direct (column-based) storage for selected modules.

Description

In Mendix, associations can be stored in two ways: in a separate association table or directly as a column in the entity's database table. Direct storage offers better performance for one-to-one and one-to-many associations by avoiding extra join queries.

This extension provides a simple UI within Studio Pro to bulk-update associations across one or more modules to use direct (column) storage.

Features

• • Lists all modules in your Mendix app
  • Select one or more modules to update
  • Converts all associations and cross-associations from association table storage to direct column storage
  • Supports both light and dark mode in Studio Pro

Usage

1. 1. Open your Mendix app in Studio Pro.
   2. Go to Extensions > Low code connect > Set associations direct.
   3. Select the modules you want to update.
   4. Click Set associations direct.
   5. The extension reports how many associations were updated.

Typical Use Case

When migrating or optimizing a Mendix application, you may want to switch associations from table-based storage to direct column storage for better query performance. Doing this manually for each association is tedious. This extension automates the process across entire modules in one click.

Compatibility

• • Mendix Studio Pro 10.21.0 or later