[wp-hackers] Is there a limit to the number of sub categories?

Viper007Bond viper at viper007bond.com
Sun Mar 9 09:57:33 GMT 2008


It's a BIGINT with a 20 digit limit. ;)

On Sat, Mar 8, 2008 at 5:27 PM, Dan Larkin <nitephire at gmail.com> wrote:

> On 3/8/08, Viper007Bond <viper at viper007bond.com> wrote:
> >
> > The only limit to categories that I know of is the number that MySQL can
> > store. Categories are stored in the same table as tags and you can have
> > something like 99999999999999999999 (or is it "just" 2^20?) different
> > categories and tags.
>
>
> I can't say I know what's causing the issue, but I just thought I'd point
> out that the limit should be 2^64 entries, seeing as the ID field in the
> database is a BIGINT type.  There may just be performance issues when
> dealing with a large number of categories.
>
> :: Dan Larkin
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
>



-- 
Viper007Bond | http://www.viper007bond.com/ | http://www.finalgear.com/


More information about the wp-hackers mailing list