# Query_time: 6.081227 Lock_time: 0.000085 Rows_sent: 1 Rows_examined: 1339
SELECT COUNT(id) FROM `article` WHERE `category` = 'shkrime-te-perkthyera'
Is there a way to speed it up. Should I index the category column?
Or what do you suggest? I use this query to get the number of articles on that category!