Re: Join Limits

2005-03-07 Thread SGreen
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 [

Re: Join Limits

2005-03-07 Thread Greg Fortune
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

RE: Join Limits

2005-03-07 Thread Kevin Cowley
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

Re: Join Limits

2005-03-07 Thread Eric Bergen
wrote: > Does anyone know if there is a method of circumventing or changing the > default join limits of 64 tables or 1024 columns? We're running Mysql > 4.1.4 using MyISAM tables > > Kevin Cowley > Product Development > Alchemetrics Ltd > SMARTER DATA , FASTER >

Join Limits

2005-03-07 Thread Kevin Cowley
Does anyone know if there is a method of circumventing or changing the default join limits of 64 tables or 1024 columns? We're running Mysql 4.1.4 using MyISAM tables Kevin Cowley Product Development Alchemetrics Ltd SMARTER DATA , FASTER Tel: 0118 902 9000 (swithcboard) Tel: 0118 902