Cascading Dropdown causing duplicated rows in a list

[sdavies68]

Hi Guys,

I have 3 cascading dropdowns in the form which is causing all the items to repeat.



In this table I have only 1 record, but it repeats 4230 times.

This is the config in the backend



The plugin is watching a field from another group in the same form.

If I unpublish these three items, it displays just the single row as it should



Correct output

 

[troester]

I asssume you have a join in your list settings (Data/Joins).
Set display mode = "merge rows"

 

[sdavies68]

I do, but when I do the merge rows it takes about 30 seconds to load the data for a single record. The problem did not happen with older versions of fabrik (I am converting from J2.5 to J3.4). When I have my full table of 24,000 records its takes over 15 minutes to display them all.

If I disable the 3 cascading joins the problem goes away.

I have also replaced the cascading joins with calc fields now and its working fine.

 

[troester]

To speed up your list view you can
in list settings/Advanced: set "Add DISTINCT" = no
in element/List view settings: set "include in list query"=no if you don't need it in the list

in general:
make sure that elements used in list joins, used as value for dbjoin and cdd elements, used in list filters have an index added in the database table

 

[cheesegrits]

Speed / repeat issues involving CDD's are pretty much always down to not using normalized data with unique foreign keys.

How are the "foreign keys" on your CDD's configured?

-- hugh