Daniel Berlin <[EMAIL PROTECTED]> wrote on 30/05/2005 06:41:54: > On Sun, 2005-05-29 at 12:50 +0200, Giovanni Bajo wrote: > > Michael Veksler <[EMAIL PROTECTED]> wrote: > > > > > 3. Nontrivial search of GCC Bugzilla are, sometimes, > > > extremely slow (over a minute). > > > > 3 could be worked on (Daniel?) > > Send me the URL's for the buglists and i'll look at the queries (The url > for the buglist contains the query). > > A lot of this is mysql's query engine being stupid, and is hopefully > fixed in 4.x or 5.x (sourceware is still on 3.x). > > I'm happy to optimize the searchs as best i can (by adding lame extra > indexes if necessary :P) It is difficult to reproduce because behavior changes over time. 2 hours ago I was getting time-out even for: http://gcc.gnu.org/bugzilla/show_bug.cgi?id=21808 Now, it takes about 2 seconds. Here is a synthetic test query that take only 15 seconds ATM: http://gcc.gnu.org/bugzilla/buglist.cgi?query_format=&short_desc_type=allwordssubstr&short_desc=&known_to_fail_type=allwordssubstr&known_to_work_type=allwordssubstr&long_desc_type=allwordssubstr&long_desc=float-store+ICE&bug_file_loc_type=allwordssubstr&bug_file_loc=&gcchost_type=allwordssubstr&gcchost=&gcctarget_type=allwordssubstr&gcctarget=&gccbuild_type=allwordssubstr&gccbuild=&keywords_type=allwords&keywords=&bug_status=RESOLVED&bug_status=CLOSED&emailassigned_to1=1&emailreporter1=1&emailtype1=substring&email1=&emailassigned_to2=1&emailreporter2=1&emailcc2=1&emailtype2=substring&email2=&bugidtype=include&bug_id=&votes=&chfieldfrom=&chfieldto=Now&chfieldvalue=&cmdtype=doit&order=Bug+Number&field0-0-0=noop&type0-0-0=noop&value0-0-0= A more sensible query takes 8 seconds: http://gcc.gnu.org/bugzilla/buglist.cgi?query_format=&short_desc_type=allwordssubstr&short_desc=&known_to_fail_type=allwordssubstr&known_to_work_type=allwordssubstr&long_desc_type=allwordssubstr&long_desc=float-store+ICE&bug_file_loc_type=allwordssubstr&bug_file_loc=&gcchost_type=allwordssubstr&gcchost=&gcctarget_type=allwordssubstr&gcctarget=&gccbuild_type=allwordssubstr&gccbuild=&keywords_type=allwords&keywords=&bug_status=UNCONFIRMED&bug_status=NEW&bug_status=ASSIGNED&bug_status=SUSPENDED&bug_status=WAITING&bug_status=REOPENED&bug_status=VERIFIED&emailassigned_to1=1&emailreporter1=1&emailtype1=substring&email1=&emailassigned_to2=1&emailreporter2=1&emailcc2=1&emailtype2=substring&email2=&bugidtype=include&bug_id=&votes=&chfieldfrom=&chfieldto=Now&chfieldvalue=&cmdtype=doit&order=Bug+Number&field0-0-0=noop&type0-0-0=noop&value0-0-0=
- Re: What is wrong with Bugzilla? [Was: Re: GCC and Floatin... Daniel Berlin
- Re: What is wrong with Bugzilla? [Was: Re: GCC and Fl... R Hill
- Re: What is wrong with Bugzilla? Russ Allbery
- Re: What is wrong with Bugzilla? R Hill
- RE: What is wrong with Bugzilla? Dave Korn
- RE: What is wrong with Bugzilla? Daniel Berlin
- RE: What is wrong with Bugzilla? Dave Korn
- RE: What is wrong with Bugzilla? Daniel Berlin
- RE: What is wrong with Bugzilla? Dave Korn
- Re: What is wrong with Bugzilla? [Was: Re: GCC and Floatin... Daniel Berlin
- Re: What is wrong with Bugzilla? [Was: Re: GCC and Fl... Michael Veksler
- Re: What is wrong with Bugzilla? [Was: Re: GCC and Floatin... Toon Moene
- Re: What is wrong with Bugzilla? [Was: Re: GCC and Fl... Robert Dewar
- Re: What is wrong with Bugzilla? [Was: Re: GCC an... Laurent GUERBY
- Re: What is wrong with Bugzilla? [Was: Re: GC... Robert Dewar
- Re: What is wrong with Bugzilla? [Was: Re... Vincent Lefevre
- Re: What is wrong with Bugzilla? [Was: Re: GCC and Fl... Vincent Lefevre
- Re: What is wrong with Bugzilla? [Was: Re: GCC an... Andreas Schwab
- Re: What is wrong with Bugzilla? [Was: Re: GC... Vincent Lefevre
- Re: What is wrong with Bugzilla? [Was: Re... Andreas Schwab
- Re: What is wrong with Bugzilla? [Wa... Vincent Lefevre