Related Lists (with too many elements)

 
1
0
-1

Hello and good day, experts.

I have to implement an asset classification system based on the UNSPSC standard. This classification makes use of 4 hierarchical lists: Segment, family, class and product. According to this there are 56 segments, 362 families, 2113 classes and 19476 products.

If I make a form to capture the data of the asset that the 4 related lists are included according to the standard in related selectboxes (with options based on Grouping), the system responds very slowly (in fact also the form builder), since as the boxes are filled (I assume) the necessary visualization operations of the dependent lists are made.

How could this operation be done so that the system respond faster?

    CommentAdd your comment...

    1 answer

    1.  
      2
      1
      0

      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:

       

       

       

        CommentAdd your comment...