Querying large table

2007-03-29 Thread Shadow
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='' But each query takes ~ 10seconds. Its really slow. Can anybody propose some optimization?

mysql@lists.mysql.com

2001-02-25 Thread shadow
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:Shadow Inc. >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: