[Attila Balazs]

First of all I would like to apologize about my bad english. 

 

We have a problem with flexigrid and GC. I use GC at our webshop backend. But when we try to test the system with a lot of products. (product > 30K) . I start viewing our servers mysql-slow-query logs and i found this:

# Query_time: 24.654583 Lock_time: 0.048581 Rows_sent: 1 Rows_examined: 19510
SELECT COUNT(*) AS `numrows`
FROM (`product`)
WHERE `product`.`product_id` =  '55230'

And its list all of pk id-s in our porduts page. Which services use this query, and how can I turn it of or optimazing to run page fast. 

[victor]

SELECT Cout(*) is a very fast query. I think you have problems with index. Is product_id PK?

[Freddy Sidauruk]

yea, the best answer select count (*) is it solved ?