Brake on the use of filters

ggppdk
Offline
Administrator

12 years 10 months ago #35338 by ggppdk

Replied by ggppdk on topic Brake on the use of filters

Hello,

so you have 6 filters and each of them takes 1-1.5 seconds to generate

1. How many items do you have in your site totally ?
2. How many items does the current category have (including subcategories if you have enabled listing subcategory items too)?

-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star review. Thanks!

Please Log in or Create an account to join the conversation.

Miken
Topic Author
Offline
Premium Member

12 years 10 months ago #35339 by Miken

Replied by Miken on topic Brake on the use of filters

ggppdk wrote: Hello,

so you have 6 filters and each of them takes 1-1.5 seconds to generate

1. How many items do you have in your site totally ?
2. How many items does the current category have (including subcategories if you have enabled listing subcategory items too)?

1. only about 1500 items
2. In the category of small 180 positions

Flexicontent 3.1.1 & Joomla 3.7.1

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

12 years 10 months ago #35341 by ggppdk

Replied by ggppdk on topic Brake on the use of filters

Hello,
the number of items is relative small

If you are working online please give me admin access to review this, and also tell me the category id of your category

Regards

Please Log in or Create an account to join the conversation.

Miken
Topic Author
Offline
Premium Member

12 years 10 months ago #35343 by Miken

Replied by Miken on topic Brake on the use of filters

ggppdk wrote: Hello,
the number of items is relative small

If you are working online please give me admin access to review this, and also tell me the category id of your category

Regards

ok. in PM

Flexicontent 3.1.1 & Joomla 3.7.1

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

12 years 10 months ago #35345 by ggppdk

Replied by ggppdk on topic Brake on the use of filters

Please include the category id of the category that will show the performance issue

Please Log in or Create an account to join the conversation.

Miken
Topic Author
Offline
Premium Member

12 years 10 months ago #35346 by Miken

Replied by Miken on topic Brake on the use of filters

Besides, there is still a problem with "Advanced cache".If when you go to another page crashes

Fatal error: Class 'JFile' not found in /home/u******/*********.ru/www/components/com_flexicontent/views/category/view.html.php on line 455

Flexicontent 3.1.1 & Joomla 3.7.1

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

12 years 10 months ago #35347 by ggppdk

Replied by ggppdk on topic Brake on the use of filters

Hello,
a file is not loaded

Please add:
(just above the line that gives you this error),
i will commit this change/fix for next version)

Code:

jimport('joomla.filesystem.file);

Please Log in or Create an account to join the conversation.

Miken
Topic Author
Offline
Premium Member

12 years 10 months ago #35348 by Miken

Replied by Miken on topic Brake on the use of filters

ggppdk wrote: Hello,
a file is not loaded

Please add:
(just above the line that gives you this error),
i will commit this change/fix for next version)

Code:

jimport('joomla.filesystem.file);

it works

Thank

Flexicontent 3.1.1 & Joomla 3.7.1

Please Log in or Create an account to join the conversation.

Miken
Topic Author
Offline
Premium Member

12 years 9 months ago #35481 by Miken

Replied by Miken on topic Brake on the use of filters

search problems led to sql queries. That form filters.

Code:

SELECT fi.value AS value, fi.value AS text, COUNT(DISTINCT i.id) as found 
  FROM j25_content AS i JOIN j25_flexicontent_fields_item_relations AS fi 
  ON i.id = fi.item_id 
  LEFT JOIN j25_flexicontent_items_ext AS ie 
  ON ie.item_id = i.id 
  LEFT JOIN j25_flexicontent_types AS ty 
  ON ie.type_id = ty.id 
  LEFT JOIN j25_flexicontent_cats_item_relations AS rel 
  ON rel.itemid = i.id 
  LEFT JOIN j25_categories AS c 
  ON c.id = i.catid 
  LEFT JOIN j25_users AS u 
  ON u.id = i.created_by 
  WHERE 1 
  AND rel.catid IN ('22') 
  AND ( i.state IN (1, -5) OR i.created_by = 0 ) 
  AND ( ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= UTC_TIMESTAMP() ) OR i.created_by = 0 ) 
  AND ( ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= UTC_TIMESTAMP() ) OR i.created_by = 0 ) 
  AND i.id IN (SELECT id 
  FROM j25_content c JOIN j25_flexicontent_fields_item_relations rel 
  ON rel.item_id=c.id 
  AND rel.field_id = 19 
  WHERE 1 
  AND (value='20' ) 
  GROUP BY c.id) 
  AND fi.field_id =15 
  GROUP BY value

Each query is about 2 seconds. And as much as they added to the filter category. in my case, these requests 5 - 6. What to do about it is not yet known.

Flexicontent 3.1.1 & Joomla 3.7.1

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

12 years 9 months ago #35483 by ggppdk

Replied by ggppdk on topic Brake on the use of filters

Hello,

Yes yes i know that these are the queries,

i know exactly , because i wrote them a few weeks ago

,
just last couple of days did not have time to test, and i needed a big test site , i have one with 12000 items, and if needed i will also add massively some custom field values with a small custom PHP script that generates random values

your feedback is always helpful, because users will always tell you something more than you already know or something you did not notice

now , i have setup the test site, i hope i will test fix the filters performance tomorrow or the day after or remove the code that causes the problem

again thanks for feedback

Please Log in or Create an account to join the conversation.