Custom fields schema

[Maxwell Kanat-Alexander]

On Wed, 2005-01-26 at 12:05 -0700, Kevin Benton wrote:
> If we have Bugzilla administer the fields itself, there are optimization
> considerations.
> [snip]

	Actually, with "fields-as-columns," we have an unknown number of
indexes required to make the one-index-per-query MySQL perform properly.

	If we do "fields-as-rows," we create the indexes once with checksetup,
and never worry about them again.

	-Max

	P.S. It's polite to trim quotes down, so that you don't send hunks of
stuff that the list has already seen. :-)
-- 
Max Kanat-Alexander
Technical Support Manager, USA
Kerio Technologies, Inc.
2350 Mission College Blvd., Suite 400
Santa Clara, CA 95054
Phone: (408) 496-2500
Fax: (408) 496-6902
http://www.kerio.com/support.html