Hi,
I'm using a dedicated server for a single website with joomla and K2 component as primary content component and a module named "News Show Pro GK5", My website is News/blog based website with more than 200k items.
Server specification Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz 10 of Cores, 20 of Threads Ram: 60GB SSD:250 (OS and i think DB) HDD: 2TB
PHP 7.3
MySQL 5.7
Website load time is very slow and i optimized page but the server response time is very slow, after inspection i enabled slow query log and i found bellow query which is repeated in slow query log file and Query_time is vary from 2 second to 8 second ... how can i optimize or solve this issue?
<pre>
Query_time:4.012262 Lock_time:0.000219 Rows_sent:28 Rows_examined:191584 SELECT i.*, c.name as categoryname,c.id as categoryid,c.alias as categoryalias, c.params as categoryparams FROM y_k2_items as i RIGHT JOIN y_k2_categories AS c ON c.id =i.catid WHERE i.published =1 AND i.access IN(1,1) AND i.trash =0 AND c.published =1 AND c.access IN(1,1) AND c.trash =0 AND( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2019-08-21 09:07:45' ) AND ( i.publish_down ='0000-00-00 00:00:00' OR i.publish_down >='2019-08-21 09:07:45' ) AND c.id IN (100,1,3,So on) ORDER BY i.id DESC LIMIT 0, 28; </pre>

Thanks

k2: V2.9.0
Joomla 3.9.11 Release

thanks for response.

Before install i have 2 question:
1- is that k2 version stable for live website?
2- the mentioned query genetrating from k2 or mentioned module?

Before install i have 2 question:
1- is that k2 version stable for live website?
2- the mentioned query genetrating from k2 or mentioned module?