Hi

You can add a database index to the 'foreign key or search' column in your lookup tables to speed up the database.

For example, there is a similar app to yours called "ISIC List" in the Joget Marketplace which I will use as an example. This demonstration app also has 4 cascade select box.

The table structure looks like this:

CREATE TABLE `app_fd_j_class` (
   `id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
   `c_Group` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
   `c_Description` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

The form will use the "c_Group" column to search and populate the "Class" select box. You can use the following SQL to add an index on "c_Group" column for performance (Below example based on MySQL database):

• ALTER TABLE 'app_fd_j_class` CHANGE `c_Group` `c_Group` VARCHAR(100) NULL ;
• ALTER TABLE 'app_fd_j_class` ADD INDEX `KeyGroup` (`c_Group`);

Further Reading:

• Performance Optimization and Scalability Tips
• Dynamic Cascading Drop-Down List