⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

  •     

profile picture

Speed up flexigrid (I have 30K items in table)



Attila Balazs

Attila Balazs
  • profile picture
  • Member

Posted 18 October 2014 - 14:56 PM

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

victor
  • profile picture
  • Member

Posted 19 October 2014 - 07:41 AM

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


Freddy Sidauruk

Freddy Sidauruk
  • profile picture
  • Member

Posted 20 October 2014 - 04:56 AM

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