Hello everyone, have a general question regarding K2 extrafields.

I have a category that displays a list of items and each item has 3 extrafields. however this makes the page load time drastically long. When I remove the extrafields group from the category, the page loads instantly.
Too many database queries, and I am only showing 10 items per page.

is there any way too enhance the performance ? a work around to reduce the number of queries ?

Regards

Is caching enabled in your site?

Hi Krikor,
I had to disable the caching. when it is enabled, it enhances the site's speed, but it caches the rating values, user status, and other dynamic data.

@Yassine Essaadi

K2 extra fields do not execute extra database queries so something else is slowing down your site. Since you see a lot of queries you can check which database table they are querying and which extension triggers them.

Hi Lefteris,
I am quite sure it's the extrafields, I disabled all the plugins and modules, and the thing is, the moment I remove the extrafields group from the category, it all goes back to normal.

I am also sure about what i wrote... What kind of extra fields are you using there? Do you have anything like a one hundred extra fields in the group?

Hi,
I am using multi-selects. and yes, one of the multi-selects have about 100 options.

K2 is not doing any fancy things with extra fields so it should not be slow even with 100 options. Do you use any extension that is filtering items based on the extra fields? What's the page that it is slow? Is it the item view page?

No I am not using any extra extensions on this page. And it is the category_item view (listings). the item view loads pretty fast.

Is there a link to the page with the issue?