I would like to ask....why the category list view page loading time is very slow (around 10sec even i have only 10 article in category list) .
I have added around 30 custom fields for 1 article. Anyone can tell me how to solve it ??
I added 30 custom fields for one specific category article for category list views
normal loading speed for category list view
Very slow loading in category view page e.g over 10 sec for only 10 article list in category page
Labels |
Added:
?
|
Category | ⇒ | com_content com_fields |
How about if I need to use Chinese Characters ??
I used the English Characters for the custom field and I duplicated the article to 200 copied and try to load in Category list view. Unluckily, the loading time over 1 min in the page. does the custom field cannot over 30 items for article ??
Status | New | ⇒ | Discussion |
Can you enable a Joomla! Debug mode and provide the link so we can see the output?
Sorry I can't provide the link because this is in the internal network.
But i enabled it and it shows nothing.....
Just load over 1 min if all custom field enabled.
It made me frustrated.......
Just load over 1 min if all custom field enabled
trying displaying less articles in category view, e.g. with pagination
or unpublish some of the fields and retry
or both the above
Debug statistics are really needed to know more
@ggppdk ...
if with pagination, this is normal time.
But, how if I need to show all this category article in this page ?
can solve this problem if the article with custom field (over 20 custom fields) ??
I build the another new joomla3 and with 30 custom fields in article.
This situation is appeared again. if no custom field for article, this is normal speed in show all article.
If enable custom field , the loading time is slow.....
this is my information in developer in chrome...
anyone can solve it ??
thx
Please enable Joomla debug in global configuration and post the results. They will be at the bottom of the page
That's not the issue. You need to look down through the queries and which ones take the longest time, these are the ones which matter.
there a plenty of record .....and these queries are around 4.x ms ~ 0.6ms .........then ...is it related to over 30 custom field for 1 article ??
That query is fetching all customfields for that 1 article which takes 3.41ms so over 30 articles that would be 103ms which is nothing.
You need to find where the query gets slow. They are usually backgrounder with red on the time.
Are you on Joomla! 3.7.5?
http://wilwil.net/dev/alex/staff-list
http://wilwil.net/dev/alex/administrator/
admin: admin for the admin page.
Here is my another sample joomla and article also have 30 custom fields.
In this category list view, it also need to around 10sec for the categories list...
please delete Account-Details for Security-Reasons.
http://wilwil.net/dev/alex/administrator/
admin: admin for the admin page.
I just want to anyone to check / verify what I setting is wrong for this situation (Category view is very slow)
@laoneo Can you take a look at this? It appears the category view is generating a query for every single article to fetch the field values??
Surely we should be able to get these in a single query since we have the article IDs rather than doing them individually?
It is like that as we don't have batch events (you remember, we were discussing it at JDay UK). So there is not much we can do here, to not break BC. But having 10 extra queries should not cause such of an overhead. As you already pointed out before, there must be some queries which are causing the delay, which should be visible from the debug console.
What I would try to is to test it on a fresh joomla installation, perhaps there are other extensions interfering.
Very good point @laoneo I've just done a comparison on his site. it's only using 51.2ms for the 128 queries for the article fields, infact the DB Queries are not using much at all in the grand scheme of things.
@wilsontse88 can you disable the Joomla! Email cloak plugin?
And also you need to upgrade to PHP7. Since you are on 5.3...........
I tried to fresh joomla installation in my another webhosting server. And I create around 30 custom fields for 1 category article.
If i disabled the custom fields, the loading is backed to normal.
If i enabled these custom field, the loading is 5 times compared to before. (Even my category list view is only show the title , and without intro image fields)
For the previous Joomla, my company server is set on php 5.3 and I cannot upgrade on this php version.
It’s mainly down to the email cloak plugin which I have disabled on your
site. The problem is each article is parsed so when you have custom fields
these are also parsed by the content plugins. The email cloak has some
complex regex to find the matches which really slows things down. You
should get up to a usable speed with this disabled.
But you NEED to upgrade to PHP7 asap since 5.3 is absolute and slow in
comparison to PHP7 which offers massive improvements. You can run PHP7
along side existing versions with FPM. Your head of IT / Systems should be
able to do this, otherwise you will start having support issues in the very
near future.
Tony Partridge
On 21 August 2017 at 10:00:39, wilsontse88 (notifications@github.com) wrote:
@laoneo https://github.com/laoneo @tonypartridge
https://github.com/tonypartridge
I tried to fresh joomla installation in my another webhosting server. And I
create around 30 custom fields for 1 category article.
If i disabled the custom fields, the loading is backed to normal.
If i enabled these custom field, the loading is 5 times compared to before.
(Even my category list view is only show the title , and without intro
image fields)
For the previous Joomla, my company server is set on php 5.3 and I cannot
upgrade on this php version.
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
#17627 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/ABVglhyIjs_q0NF7W4Glla3dCptJ5BVMks5saUc3gaJpZM4O8Y4k
.
Oh...that really have improvement when I disabled the "Email Cloak plugin". !!!!!!1
But I would like to ask that ...does it any problem or another issue will appear if I disable this plugin??
If your website is public facing and you have email addresses then I would
advise you use the regular labs email cloak plugin. Otherwise, no it has no
effect. The idea of the plugin is to wrap emails in html/js so bots cannot
pick them up in simple terms.
Tony Partridge
On 21 August 2017 at 10:19:57, wilsontse88 (notifications@github.com) wrote:
@tonypartridge https://github.com/tonypartridge
Oh...that really have improvement when I disabled the "Email Cloak plugin".
!!!!!!1
But I would like to ask that ...does it any problem or another issue will
appear if I disable this plugin??
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
#17627 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/ABVglli4qMVW3H-S8yKxHjN-JhT9BFdNks5saUu8gaJpZM4O8Y4k
.
Can we get a close on this?
Excuse me, I would like to ask...does it normal if the page loading time around 5~7sec . even i stop the email cloaking plugin?
I will clone the joomla for the external hosting later..... and hope all of you can help me to check it.
Status | Discussion | ⇒ | Closed |
Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2017-08-22 04:37:02 |
Closed_By | ⇒ | franz-wohlkoenig |
Closed_By | franz-wohlkoenig | ⇒ | joomla-cms-bot |
Set to "closed" on behalf of @franz-wohlkoenig by The JTracker Application at issues.joomla.org/joomla-cms/17627
closed as stated above. @wilsontse88 please ask further help on the forums. This repository concerns Joomla coding.
Excuse me, I would like to ask...does it normal if the page loading time around 5~7sec . even i stop the email cloaking plugin?
About email cloak plugin, it surely needs improving, even if this means making some trade-off
Please test with only English characters.