On Fri, Nov 02, 2001 at 03:37:53PM -0800, another oracle dba wrote: > Hi. > > I have a query which completes in about 9 sec when executed alone, > but the time grows dramatically when I execute several similar > queries at the same time. If I execute 3 queries the time grows to > 27-40sec, for 5 queries - toabout 1min, for 20 queries ran > simultaniously the time jumps to 2-4 min per query.
Ouch. > How do I go about increaseing performance. The tables included in > the queries have indices on the fields in the where clause, but they > are not composite indices. Would it help to combine these multiple > indices to one or two composite indices? Can you show us the table structures, query, and the output of EXPLAIN SELECT on the query? > Does mysql have something like oracle's explain plan to see how > exactly is the query executed? Anything else? EXPLAIN SELECT ... 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 60 days, processed 1,316,000,005 queries (253/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
