Custom fields schema

Maxwell Kanat-Alexander mkanat at
Thu Jan 27 04:02:17 UTC 2005

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.


	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

More information about the developers mailing list