Re: innodb/mysql slow returning anything other than primary key

2002-12-17 Thread Heikki Tuuri
ranch already in the root. This could cause unnecessary table scans in SQL queries. ... " Regards, Heikki - Original Message - From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, December 18, 2002 1:33 AM Subject: Re: innodb/mysql sl

Re: innodb/mysql slow returning anything other than primary key

2002-12-17 Thread Heikki Tuuri
Walt, - Original Message - From: "walt" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Tuesday, December 17, 2002 1:58 AM Subject: innodb/mysql slow returning anything other than primary key > I've run into an interesting problem. I have a large innodb table (2274962 > rows