Re: Oracle interMedia as a Web Search Solution?

[Quoted] Can you generate an execution plan? (in sqlplus set autotrace to on environment autotrace default=false on). That might tell us something. Jim
<mlecza_at_my-deja.com> wrote in message news:7u53jt$tu8$1_at_nnrp1.deja.com...
> Thanx for your reply.
>
> My query look like this:
>
> SELECT END_DATE, HEADING, ITEMNUMBER,BID, START_BID FROM item_search
> WHERE contains(HEADING,'bean%',1) >0 or contains(DESCRIPTION,'bean%',2)
> >0 order by end_date, itemnumber
>
> The SORT_AREA_SIZE was set to 65536 - I doubled it and the performance
> is exactly the same.
>
> If you have any other suggestions - I'm listening.
>
> Thanx again!
>
>
> In article <3805ddc9.4021322_at_newshost.us.oracle.com>,
> jkallman_at_us.oracle.com wrote:
> > On Wed, 13 Oct 1999 17:24:41 GMT, mlecza_at_my-deja.com wrote:
> >
> > >Has any one used Oracle interMedia as a search engine for a website?
> > >
> > >We started playing around with it. I loaded up a table with 15,000
> > >records and started messing with queries - It performed great until I
> > >started adding ORDER BY to the query.
> > >
> > >My fear is that is will just not be fast enough to handle hundreds of
> > >thousands of items with the performace we are looking for.
> > >
> > >I am having trouble finding any kind of reviews (other than Oracle's
> > >reviews) on the product.
> > >
> > >FYI - We have Oracle 8i runing on a Sun Ultra 10 with 500MB RAM
> >
> > What are you ordering by? Is it by the SCORE operator or some other
> > column? What is your database parameter SORT_AREA_SIZE set to?
> >
> > If your interMedia Text query is performing very fast, and your sort
> > operation is slow, it may have nothing to do with interMedia Text.
> >
> > >
> > >
> > >Sent via Deja.com http://www.deja.com/
> > >Before you buy.
> >
> > Thanks!
> >
> > Joel
> >
> > Joel R. Kallman
> > Oracle Service Industries
> > Columbus, OH http://govt.us.oracle.com
> > jkallman_at_us.oracle.com http://www.oracle.com
> >
> > ----
> > The statements and opinions expressed here are my own
> > and do not necessarily represent those of Oracle Corporation.
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Oct 14 1999 - 21:12:01 CEST