List speed is extremely slow

[mamies]

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.

 

[troester]

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?

 

[cheesegrits]

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