In news:[EMAIL PROTECTED], Shadow <[EMAIL PROTECTED]> wrote:
> 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. You may add an index on `items`.`ctg` if there is none. Maciek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
