Keyword

Repeating Queries 70+ on Item Page

  • vecdom
  • vecdom's Avatar Topic Author
  • Offline
  • New Member
More
13 years 3 weeks ago #99743 by vecdom
Repeating Queries 70+ on Item Page was created by vecdom
Hi I have an issue with k2 making too many requests.... These are same set of requests that are repeating multiple times on all of the item pages....

 

I have searched and searched forum for weeks and couldn't find a solution so help would be really appreciated....

 

These is my current configuration:


Joomla Gzip and Caching (xCache) - global configuration - enabled
System cache plugin enabled
Gantry framework cache enabled
Rokgzip is enabled for CSS and JavaScript compression
SEF is OFF
Category parameters - catalog mode is set to YES.
K2 parameters: - comments are disabled, - share code is entered, - user profiles are disabled, - "item counter next to the category..." set to NO- "display items from both parent and children cat..." set to NO- "disable ordering compacting" set to YES

 

I even tried caching queries themselves using mysql config file by JoomlaWorks posted here - snipt.net/fevangelou/optimised-mycnf-configuration/ - 9 to 11 queries get cached but the rest don't...

 

Example of repeating queries on item page: bit.ly/rcXfPb

 


SELECT parent   FROM jos_k2_categories   WHERE id = 250   LIMIT 1

SELECT parent   FROM jos_k2_categories   WHERE id = 292   LIMIT 1

SELECT parent   FROM jos_k2_categories   WHERE id = 5   LIMIT 1

SELECT catid   FROM jos_k2_items   WHERE id = 1750   LIMIT 1

SELECT parent   FROM jos_k2_categories   WHERE id = 250   LIMIT 1

SELECT parent   FROM jos_k2_categories   WHERE id = 292   LIMIT 1

SELECT parent   FROM jos_k2_categories   WHERE id = 5   LIMIT 1

SELECT catid   FROM jos_k2_items   WHERE id = 1750   LIMIT 1



 

Another xample of the repeating queries set on item page: bit.ly/n4yDpS

 


SELECT catid   FROM jos_k2_items   WHERE id = 1736   LIMIT 1

SELECT parent   FROM jos_k2_categories   WHERE id = 248   LIMIT 1

SELECT parent   FROM jos_k2_categories   WHERE id = 292   LIMIT 1

SELECT parent   FROM jos_k2_categories   WHERE id = 5   LIMIT 1

SELECT catid   FROM jos_k2_items   WHERE id = 1736   LIMIT 1

SELECT parent   FROM jos_k2_categories   WHERE id = 248   LIMIT 1

SELECT parent   FROM jos_k2_categories   WHERE id = 292   LIMIT 1

SELECT parent   FROM jos_k2_categories   WHERE id = 5   LIMIT 1

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


Powered by Kunena Forum