search

GavickPro / News-Show-Pro-GK5

Advanced Joomla! content module.
28 stars 37 forks source link

Slow query ISSUE #352

Closed klausveliu closed 8 years ago

klausveliu commented 8 years ago

Hello, We are using News Show Pro GK5. I must say its a wonderful module from its features, so many features in one module...

My issue its very serious!!! This module content its being cached by Joomla, but when many articles are added to often the cache its cleaned and regenerated. In this moment the modules generates slow queries causing my website(www.newsbomb.al) to crash.

SELECT DISTINCT i.*, g.title AS groupname, c.name AS category, v.name AS author, w.name as moderator, u.name AS editor FROM p38xt_k2_items as i LEFT JOIN p38xt_k2_categories AS c ON c.id = i.catid LEFT JOIN p38xt_viewlevels AS g ON g.id = i.access LEFT JOIN p38xt_users AS u ON u.id = i.checked_out LEFT JOIN p38xt_users AS v ON v.id = i.created_by LEFT JOIN p38xt_users AS w ON w.id = i.modified_by WHERE i.trash=0 ORDER BY i.id DESC LIMIT 0, 50;

My feed its just the image, title, create date, introtext of latest articles, Could your help me how to fix this issue?!

screenshot_2

screenshot_1

dziudek commented 8 years ago

Hello,

In my opinion this query is not from our module - we have removed queries with distinct for k2 a long time ago and I cannot find this query in our module.

klausveliu commented 8 years ago

Sorry maybe I have bothered you. When I tested the query in phpmyadmin the result was that of the latest articles... Thank you for the support! Keep going with your great work (Y)