opment
> > Alchemetrics Ltd
> > SMARTER DATA , FASTER
> > Tel: 0118 902 9000 (swithcboard)
> > Tel: 0118 902 9099 (direct)
> > Web: www.alchemetrics.co.uk
> > Email: [EMAIL PROTECTED]
> >
> > > -Original Message-
> > > From: Eric Bergen [
hemetrics.co.uk
> Email: [EMAIL PROTECTED]
>
> > -Original Message-
> > From: Eric Bergen [mailto:[EMAIL PROTECTED]
> > Sent: 07 March 2005 18:16
> > To: Kevin Cowley
> > Cc: mysql@lists.mysql.com
> > Subject: Re: Join Limits
> >
> > The join table
n [mailto:[EMAIL PROTECTED]
> Sent: 07 March 2005 18:16
> To: Kevin Cowley
> Cc: mysql@lists.mysql.com
> Subject: Re: Join Limits
>
> The join table limit in MySQL is dictated by the arch that's running
> on. 32 tables for 32bit and 64 tables for 64bit (Somebody correct me
The join table limit in MySQL is dictated by the arch that's running
on. 32 tables for 32bit and 64 tables for 64bit (Somebody correct me
if I'm wrong). I believe this is due to using a bitmap inside the join
optimizer to keep track of tables. 64 tables is a very hefty query it
makes me think that