Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: Maciej Dobrzanski (reg.mysqlposterus.com)
Date: Fri Mar 30 2007 - 03:33:56 CDT
Shadow <shadow_developeryahoo.com> 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.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql