From: Thomas Kyte Newsgroups: comp.databases.oracle.misc Subject: Re: Qestion about querying using intermedia Organization: Oracle Service Industries Reply-To: tkyte@us.oracle.com Message-ID: References: <62rrhtop5qnean8gdi09vndiufeb9gdaj9@4ax.com> X-Newsreader: Forte Agent 1.7/32.534 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 44 Date: Wed, 06 Jun 2001 11:27:18 -0400 NNTP-Posting-Host: 138.1.114.126 X-Trace: inet16.us.oracle.com 991841644 138.1.114.126 (Wed, 06 Jun 2001 08:34:04 PDT) NNTP-Posting-Date: Wed, 06 Jun 2001 08:34:04 PDT A copy of this was sent to Kev (if that email address didn't require changing) On Wed, 06 Jun 2001 01:39:47 -0700, you wrote: >Hello All, > >I am using interMedia and the problem is this. > >If I do a search where I am using more than one word or a phrase >the reponse time is extremely fast but when I query one word; say the >word help for example the hardrives light up like christmas trees. I >increased the sort_area_size to 3 megs which help speed up the more >then one word of phrase queries but didnt help and single word query. > >Also the CPU maxes out. What can I do so that people can search with >fast response times. > >Thanks, > >Kev you'll have to provide a tad more background then that. if you goto http://asktom.oracle.com/ (or www.oracle.com, or otn.oracle.com) and click on the search tab -- you'll have an intermedia search screen. The searches don't take more then 1 second using a single word. We would need to understand things like o volume of data (#rows and megabytes) o the query involved (is it a "where containts() and sysdate > column" -- mixed text and relational, just relational, etc) o how many hits your single keyword query generates vs your two keyword query o VERSIONS OF SOFTWARE -- Thomas Kyte (tkyte@us.oracle.com) Oracle Service Industries Howtos and such: http://asktom.oracle.com/ http://asktom.oracle.com/~tkyte/ Oracle Magazine: http://www.oracle.com/oramag Opinions are mine and do not necessarily reflect those of Oracle Corp