Hi,
I have 3 million row entries in my grid. To get the count of this number this query is generated
" SELECT count(*) as c FROM (SELECT * from table_name where column = 27 ) table_count "

This is taking all my server cores and is delaying my site load time.

Is there a way to optimize this????
If not how can I remove this call from the grid.