Hi, Durand! With those specs your site should be flying! We have a pretty similar site with real time 300-500 active sessions and some 130 000 to 160 000 pageviews on average day. We have been using K2 for reasons dating back to 2011 and...
Hi, sorry that I wasn't able to answer sooner. You need to modify the file at ../components/com_k2/models/itemlist.php There we modified the query string by adding FORCE INDEX (item): $query .= " FROM #__k2_items as i RIGHT JOIN...
Hi, no need to haste and flood topic with answers ;) We tackled the slow query issue. Main problem seems to be that when going past critical mass of items, about 200 000+ the form of the query isn't the best in handling that amount of...
Hi, some time ago we started suffering slow queries on our production site. We tested the K2 query issue on separate workstation from exactly same tables and there caching and query execution seems to work fine. However, the query takes...
More