Re: Qestion about querying using intermedia

A copy of this was sent to Kev <java2e_at_yahoo.com> (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_at_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