statuscount.cgi performance (WAS Re: Custom fields schema)

Fri Jan 28 23:56:22 UTC 2005

On Fri, 2005-01-28 at 14:28 -0700, Kevin Benton wrote:
> And if I'm taking 60 seconds to run a query at ~3K records, how will
> that scale when it's 100K+ records?  1M+ records?

	Well, thankfully, with indexes, it will scale very well. The only
problem with statuscount.cgi performance was indexes, and once we
resolved that, it ran pretty fast, as I recall. :-)

	-Max
-- 
Max Kanat-Alexander
Technical Support Manager, USA
2350 Mission College Blvd., Suite 400
Santa Clara, CA 95054
Phone: (408) 496-4500
Fax: (408) 496-6902
http://www.kerio.com/support.html