Custom fields schema

Myk Melez myk at mozilla.org
Fri Dec 24 02:22:50 UTC 2004


Sean McAfee wrote:

>Is this enough data to put this issue to rest?  Pretty please?
>  
>

Not really.  First, it doesn't measure the impact of indexes.  Second, 
it doesn't include the cost of looking up field IDs.  Third, it only 
measures search performance, but most queries retrieve bug data for 
specific bugs.  Fourth, it doesn't take what bbaetz says into account.  
And fifth, I never claimed bugs table columns were more performant, only 
that they were performant enough, which they are, considering the 
"custom fields" already in use as standard colums.

But the primary reason it doesn't put the issue to rest is that sparse 
fields go into separate tables under the fields-as-columns proposal as 
well, so that proposal gets any benefit to separate tables.

-myk




More information about the developers mailing list