On Tue, Apr 09, 2002 at 10:17:56AM +0200, Luke van Blerk wrote: > Hi everyone, > > I've been reading up about InnoDB tables and they seem to have lots > of advantages. I'm particularly interested in using the foreign keys > as this will save me some much need time. In the benchmark tests on > the InnoDB website they show up faster than MyISAM tables
That's a great sign for you. :-) > but will foreign keys have a slow down effect? And are there any > issues I need to know about before switching to InnoDB tables? Of course things will be slower with foreign keys. The question is how much slower. I suspect that the difference will be very, very minor. But why not run a benchmark with FKs and see? Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 63 days, processed 1,719,288,043 queries (312/sec. avg) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php