1. Fabrik 3.9 has been released. If you have updated Joomla to 3.9, this is a required update.
    Dismiss Notice

List speed is extremely slow

Discussion in 'Community' started by mamies, Nov 10, 2019 at 5:02 AM.

  1. mamies

    mamies Member

    Level: Community
    Hi Team,

    I have ran into an issue on our intranet site where the tables are extremely slow to open. The table is fairly large with over 4,500 records and quite a lot of elements.

    I noticed that the table max's out one of the CPU cores on the server for a good 20 seconds before it loads the page.

    I have enabled the debug feature in Joomla and have uploaded a text file with the info (The post was too large with it added here).

    Any help would be greatly appreciated.
     

    Attached Files:

  2. troester

    troester Well-Known Member Staff Member

    Level: Community
    Check your cascadingdropdown elements.
    Are they watching the id (PK) of the watched element (recommended)?

    If not make sure that the watched column has an index added, you may have to add it manually directly in your database with e.g. phpMyAdmin

    Do your databasejoin elements use id[recommended] as value?
     
  3. cheesegrits

    cheesegrits Support Gopher Staff Member

    Level: Community
    Yup, looks to me like you may be using a non-unique key for a CDD. So as Troester says, make sure you are using 'id' (or whatever your primary key is) as the "value". If you aren't, then you'll need to also manually update your existing data before changing the key in Fabrik.

    -- hugh
     

Share This Page