List and time loading

[arie]

Hello, I've got a list composed of joins on multiples tables.
This list is long to load (6-9 s) compared to other lists I have (2-3s).

There is a way to identify from where comes the problem? I tried though fabrikdebug=1 but that doesn't give any help about time loading.

Any advises?

 

[cheesegrits]

I see you locked this one, did you sort it out?

Note that to see Fabrik's actual profiling, enable J!'s debug mode. Our profiling is then added to the main profile in the J! debug section at the bottom of the page.

-- hugh

 

[arie]

friendly bump

 

[arie]

friendly bump

 

[arie]

Here is an updated version of the information profil. Can you help me to understand and to make some optionation

 

[cheesegrits]

For any element filters on join elements, try using the 'all data' rather than 'recorded data' for the filter method. This should save a number of fairly expensive queries.

The difference being, with 'all data', it builds the filter list by just grabbing all the rows from the joined table. For 'recorded data', we have to first query the table being displayed, find all the unique values for that join element which exist in the main table, then look those up in the joined table, which adds a layer of querying.

-- hugh