Joomla Backend - Components>Fabrik>Elements Loading Issue

[teoyh]

I have a about 5k elements in my Fabrik.

The very first time when i load elements it will take so long that sometime i get a time out error.

Is there any setting to overcome this ?

I have tried Enable big selects in Fabrik Options but that did not seems to help either.

 

[troester]

Make sure (with e.g. phpMyAdmin) that the column parent_id in #_fabrik_elements has an index added.

 

[cheesegrits]

If it doesn't have the index on parent_id (and even if it does) you should probably check all your Fabrik metadata tables, and make sure they have indexes as per:

https://github.com/Fabrik/fabrik/bl...ponents/com_fabrik/sql/install.mysql.uft8.sql

Some of those indexes were added in updates, like ...

https://github.com/Fabrik/fabrik/bl...mponents/com_fabrik/sql/updates/mysql/3.4.sql

... and there's something weird deep inside the J! updater which causes SQL updates to not be applied sometimes.

-- hugh

 

[teoyh]

I did what you all had instructed me by checking all the table to ensure that all the id have index but still cannot load it just keep spinning until time out. Forgot to mentioned that this is in my development site. Production have no such issue.

I am using development to test the php 7 so bump into this issue. But i had since switch back to php 5.6 after the element cannot load.

I was checking the mysql connection in the backend when the element list is loading , i will get the following query. Any clue what is it doing ?



There is also a difference between my development compare to Production , development have no access to internet ! Does that make a difference ?

 

[troester]

There is also a difference between my development compare to Production , development have no access to internet ! Does that make a difference ?

Not from a Fabrik site of view (if your site is running on a local web server).
#_fabrik_jsactions is storing the JS actions of your elements.

 

[cheesegrits]

Did you enable maximum error reporting? Is it giving an error message?

Most likely is memory limit, so you could try increasing that in your PHP ini.

-- hugh

 

[teoyh]

Did you enable maximum error reporting? Is it giving an error message?

Most likely is memory limit, so you could try increasing that in your PHP ini.

-- hugh

I had increase the memory limit to 512M but it still did not help
; Maximum amount of memory a script may consume (128MB)
; http://php.net/memory-limit
memory_limit=512M

I had enable maximum error report, but it will not show as the page is in a loading mode

 

[teoyh]

To overcome this issue this is what i do ;

add the filter_group number to the url so that it will reduce the loading time. Each time when i click element it will load everything , in the next version can it be set to load the first list and not everything. Subsequent loading it will base on what you last select

administrator/index.php?option=com_fabrik&view=elements&filter_group=449

 

[cheesegrits]

What is your pagination size set to (the dropdown, top right)?

-- hugh

 

[Sophist]

As Hugh has indicated this might be an issue with the number of element you are trying to display or with memory being exhausted for some other reason.

Have you tried running the SQL that you believe is causing the problem manually in e.g. phpmyadmin?

Alternatively I have a Joomla PR#19367 pending which makes the Fabrik SQL calls appear in the Joomla Debug log (at present few if any appear there). This includes both the SQL EXPLAIN and SQL execution profile for each SQL call - so if you apply this PR to your development site manually then, as long as the Joomla Elements list actually appears and doesn't time out, you should be able to review the SQL and see what is taking the most time and get some idea of what might be needed to reduce it.

 

[teoyh]

As Hugh has indicated this might be an issue with the number of element you are trying to display or with memory being exhausted for some other reason.

Have you tried running the SQL that you believe is causing the problem manually in e.g. phpmyadmin?

Alternatively I have a Joomla PR#19367 pending which makes the Fabrik SQL calls appear in the Joomla Debug log (at present few if any appear there). This includes both the SQL EXPLAIN and SQL execution profile for each SQL call - so if you apply this PR to your development site manually then, as long as the Joomla Elements list actually appears and doesn't time out, you should be able to review the SQL and see what is taking the most time and get some idea of what might be needed to reduce it.

Pardon me, but how do i pull the changes seem to be a Joomla debug enhancement.

 

[cheesegrits]

I really wouldn't advise applying PR's to your Joomla. Seeing the query isn't going to help much, I know what the query is ... I wrote the query.

Can you answer:

What is your pagination size set to (the dropdown, top right)?

-- hugh

 

[teoyh]

I really wouldn't advise applying PR's to your Joomla. Seeing the query isn't going to help much, I know what the query is ... I wrote the query.

Can you answer:



-- hugh

Hehe ...i was still trying to figure out where to find the setting for pagination size ... i look all around but could not see to find it

 

[cheesegrits]

Hehe ...i was still trying to figure out where to find the setting for pagination size ... i look all around but could not see to find it

Same place it is for all backend Joomla tables, top right.

Hugh


Sent from my Pixel 2 XL using Tapatalk

 

[teoyh]

What is your pagination size set to (the dropdown, top right)?

-- hugh

Hello ;
my Default List Limit is 20