Xref: alice comp.databases.oracle.misc:32375 comp.databases.oracle.server:51488 comp.databases.oracle.tools:25675
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!newsfeed.cwix.com!193.189.160.243!news-hub.siol.net!newscore.univie.ac.at!newsfeed.Austria.EU.net!Austria.EU.net!not-for-mail
From: "Michael W. Steidl" <mwsteidl@eunet.at>
Newsgroups: comp.database.oracle,comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools
Subject: Re: Context Server
Date: Sun, 30 May 1999 21:12:35 +0200
Organization: mws-EDV-medienwerkstatt, Vienna (Austria)
Lines: 131
Message-ID: <37518DA3.DD19EB51@eunet.at>
References: <374AD136.828DAD37@dci-ltd.com> <7igteo$oat$1@nnrp1.deja.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: fleetstreet.Austria.EU.net 928092051 16815 193.154.5.80 (30 May 1999 19:20:51 GMT)
X-Complaints-To: abuse@Austria.EU.net
NNTP-Posting-Date: 30 May 1999 19:20:51 GMT
To: graf27@my-dejanews.com
X-Mailer: Mozilla 4.5 [de] (WinNT; I)
X-Accept-Language: de

Toni,

a word on your last sentence: I have tested a context index for a table with
250.000 rows, and I have spoken to a fellow who has tested context with 4
million rows.

So it must work with more than 150.000 rows.

But it is rather hard, to index such a table with context cartdrige in one
run. I inserted about 25.000 rows at one time and waited until the DML queue
has been empty.

Michael.


graf27@my-dejanews.com schrieb:

> In article <374AD136.828DAD37@dci-ltd.com>,
>   Don Dazey <don_dazey@dci-ltd.com> wrote:
> > Hi all,
> >
> > At a client I have recently implemented context option on Oracle 8.0.5
> > running on Digital Unix version V4.0D (Rev. 878) on an Alpha.
> >
> > I will have to do capacity planning on the database server to avoid
> any
> > future performance hiccups. I will appreciate any input on the context
> > server, like any undocumented features, glitches or potholes. Does any
> > body have an estimate on the data to index ratios that the context
> > server needs?
> >
> > Any input is highly appreciated.
> >
> > Please email directly at anthony_dasari@dci-ltd.com
> >
> > Regards,
> >
> > Anthony Dasari.
> >
> > Database Consultants - Tulsa.
> >
> >
>
> Hi Anthony,
> i've running the context-cartridge on Solaris with 8.0.4. After
> installing there are some new views and packages on your ctxsys user.
> After indexing you have more Index-Tables in the Database. In relation
> to your ploicies these tables are :
>
> My Example:
>
> An context-index on 1 LONG-col in a table with 12000 entries needs
>
> SQL> desc DR_01103_I1T1
>  Name                            Null?    Type
>  ------------------------------- -------- ----
>  WORD_TEXT                       NOT NULL VARCHAR2(64)
>  FIRST_DOC                       NOT NULL NUMBER(38)
>  DOCLSIZE                                 NUMBER(38)
>  WORD_TYPE                                NUMBER(3)
>  WORD_INFO                                LONG RAW
>
> SQL> select count(*) from DR_01103_I1T1;
>
>  COUNT(*)
> ---------
>     51748
>
> SQL> desc DR_01103_KTB
>  Name                            Null?    Type
>  ------------------------------- -------- ----
>  TEXTKEY                                  VARCHAR2(256)
>  DOCID                                    NUMBER(38)
>
> SQL>  select count(*) from DR_01103_KTB;
>
>  COUNT(*)
> ---------
>     11654
>
> SQL> desc DR_01103_LST
>  Name                            Null?    Type
>  ------------------------------- -------- ----
>  SID                                      NUMBER(38)
>  IDCOUNT                                  NUMBER(38)
>  LTYPE                                    VARCHAR2(2)
>  CONTIGUOUS                               NUMBER(2)
>  DATA                                     VARCHAR2(1024)
>
> SQL> select count(*) from DR_01103_LST;
>
>  COUNT(*)
> ---------
>         1
>
> SQL> desc DR_01103_NLT
>  Name                            Null?    Type
>  ------------------------------- -------- ----
>  FIRST_DOC                                NUMBER(38)
>  IDLIST                                   LONG RAW
>
> SQL> select count(*) from DR_01103_NLT;
>
>  COUNT(*)
> ---------
>         1
>
> SQL> desc DR_01103_SQR
>  Name                            Null?    Type
>  ------------------------------- -------- ----
>  QUERY_NAME                      NOT NULL VARCHAR2(32)
>  SESSION_ID                      NOT NULL VARCHAR2(32)
>  FIRST_DOC                       NOT NULL NUMBER(38)
>  QUERY_RESULT                             LONG RAW
>
> SQL> select count(*) from DR_01103_SQR;
>
>  COUNT(*)
> ---------
>         0
>
> attention:
> tests with tables more than 150000 entries failed, there is no way to
> create the context-index !!
>
> Good Luck
> Toni
>
> --== Sent via Deja.com http://www.deja.com/ ==--
> ---Share what you know. Learn what you don't.---