Re: AW: InnoDB and foreign keys

2004-10-13 Thread John McCaskey
If you could post your table schema (SHOW CREATE TABLE table_name) and then give an example of the query that is slow on InnoDB that would help us give a better analysis. Right now it sounds like something is wrong, InnoDB is likely to be slightly slower than MyISAM because of transaction overhead

Re: AW: InnoDB and foreign keys

2004-10-13 Thread SGreen
Suggestions? Check your indexes. It sounds as though they aren't what they used to be. When you converted to InnoDB, did you accidentally move the data to a slower drive? If so, you may want to move it back to where you had the MyISAM tables. Shawn Green Database Administrator Unimin Corporatio

AW: InnoDB and foreign keys

2004-10-13 Thread Ulrich Seppi
HELLO >> does anybody know if Foreign keys increase the performance of select querys? >> example. >> DB1 has only INNODB tables. >> DB2 has the same structure as DB1 with all possible foreign keys. >> > is the same query faster on DB1 or DB2? > >Why should it increase performance? At the moment

Re: InnoDB and foreign keys

2004-10-13 Thread Jeff Smelser
On Wednesday 13 October 2004 10:33 am, Ulrich Seppi wrote: > Hello people, > does anybody know if Foreign keys increase the performance of select > querys? example. > DB1 has only INNODB tables. > DB2 has the same structure as DB1 with all possible foreign keys. Huh? You might want to read what a

Re: InnoDB and foreign keys

2004-10-13 Thread Martijn Tonies
> does anybody know if Foreign keys increase the performance of select querys? > example. > DB1 has only INNODB tables. > DB2 has the same structure as DB1 with all possible foreign keys. > > is the same query faster on DB1 or DB2? Why should it increase performance? With regards, Martijn Tonie

Re: InnoDB and foreign keys

2004-10-13 Thread SGreen
I am not certain that Foreign Keys (FKs) are even considered when evaluating a SELECT statement. I know that the indexes that the FKs point to in either table play a major role in determining the execution plan but I don't think that the FKs actually participate in SELECT queries. Now, does ha

InnoDB and foreign keys

2004-10-13 Thread Ulrich Seppi
Hello people, does anybody know if Foreign keys increase the performance of select querys? example. DB1 has only INNODB tables. DB2 has the same structure as DB1 with all possible foreign keys. is the same query faster on DB1 or DB2? regards Uli -- MySQL General Mailing List For list archives: