Hey, guys.
I have 2 tables: categories and items.
COUNT(*) categories = 63 833
COUNT(*) items = 742 993
I need to get number of items in a specific category, so I use
SELECT COUNT(*) FROM items WHERE ctg='ctg'
But each query takes ~ 10seconds.
Its really slow.
Can anybody propose some
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:Shadow Inc.
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class