On Sun, Oct 21, 2001 at 08:41:45PM +0100, Ronan Minogue wrote: > Dear Sir/Madam. > > I have written a Management Information System that has a MySQL db > running on a Linux server. There is quite a small number of tables. > However these tables are growing quickly and the queries executed > will require "LEFT OUTER JOIN" between tables. > > Example: > A sample query over 4 tables using LEFT OUTER JOIN > Table A 11000 rows > Table B 15000 rows > Table C 18000 rows > Table D 2,500,000 rows > > "Table D" will over a year will reach values of 10 to 15 million records. > > Are you aware of any benchmarks / examples of expected response > time??
Spend 20 minutes and fill table D with a lot of data and see how it performs. If it's not fast enough, look tweaking MySQL's settings (as described in the manual) for higher performance. With the detail you've given us so far, it's nearly impossible to predict the results. 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.41-max: up 45 days, processed 999,195,609 queries (252/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
