[wp-hackers] Rebuttal (re: Meta tables: Take 5)

mikeschinkel at newclarity.net mikeschinkel at newclarity.net
Fri Jul 24 17:58:43 UTC 2009


For clarity, it's not the number of types that would matter, it's the  
number of meta records that would matter.  Each meta record could  
store an int or a varchar(??).

With 100k records and 10 meta per record you can easily get 1 million+  
strings in an index which isn't nearly as efficient as ints.

JMTCW.


Sent from my iPhone

On Jul 24, 2009, at 1:50 PM, scribu <scribu at gmail.com> wrote:

> On Fri, Jul 24, 2009 at 8:44 PM, <mikeschinkel at newclarity.net> wrote:
>
>> One thing to consider; in the "standard" approach would it make  
>> sense to
>> have meta type stored in it's own table so that the type field in  
>> the meta
>> table could be an INT and thus stored and indexed efficiently?
>>
>
>
> I don't think there would be that many types to justify an  
> additional table,
> at least not at first.
>
>
> -- 
> http://scribu.net
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers


More information about the wp-hackers mailing list