Hardware and performance

SELECT COUNT query really bringing down performance