OraFAQ Forum: Text & interMedia

Home » Server Options » Text & interMedia » why so slowly?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

why so slowly? [message #76074]

Tue, 28 October 2003 15:07

rabbit
Messages: 6
Registered: October 2003

Junior Member

Hi all,
i want to creat a context index for clob column in oracle text. 2 MB files(pdf, doc, xls, ppt, htm) are stored in this column. But it is very slowly. I must c.a. 7 hours wait until index is created. I think, it is not not correct. I set the Preferenz in such a way with java.

//lexer
cstmt = conn.prepareCall("{call ctx_ddl.create_preference(?, ?)}");
cstmt.setString(1, "oracle_lexer_extern");
cstmt.setString(2, "BASIC_LEXER");
cstmt.execute();
cstmt = conn.prepareCall("{call ctx_ddl.set_attribute(?, ?, ?)}");
cstmt.setString(1, "oracle_lexer_extern");
cstmt.setString(2, "base_letter");
cstmt.setString(3, "yes");
cstmt.execute();
cstmt = conn.prepareCall("{call ctx_ddl.set_attribute(?, ?, ?)}");
cstmt.setString(1, "oracle_lexer_extern");
cstmt.setString(2, "index_stems");
cstmt.setString(3, "german");
cstmt.execute();
cstmt = conn.prepareCall("{call ctx_ddl.set_attribute(?, ?, ?)}");
cstmt.setString(1, "oracle_lexer_extern");
cstmt.setString(2, "printjoins");
cstmt.setString(3, "_-");
cstmt.execute();

//wordlist
cstmt = conn.prepareCall("{call ctx_ddl.create_preference(?, ?)}");
cstmt.setString(1, "oracle_wordlist_extern");
cstmt.setString(2, "BASIC_WORDLIST");
cstmt.execute();
cstmt = conn.prepareCall("{call ctx_ddl.set_attribute(?, ?, ?)}");
cstmt.setString(1, "oracle_wordlist_extern");
cstmt.setString(2, "stemmer");
cstmt.setString(3, "German");
cstmt.execute();
cstmt = conn.prepareCall("{call ctx_ddl.set_attribute(?, ?, ?)}");
cstmt.setString(1, "oracle_wordlist_extern");
cstmt.setString(2, "fuzzy_match");
cstmt.setString(3, "German");
cstmt.execute();
cstmt = conn.prepareCall("{call ctx_ddl.set_attribute(?, ?, ?)}");
cstmt.setString(1, "oracle_wordlist_extern");
cstmt.setString(2, "substring_index");
cstmt.setString(3, "true");
cstmt.execute();
cstmt = conn.prepareCall("{call ctx_ddl.set_attribute(?, ?, ?)}");
cstmt.setString(1, "oracle_wordlist_extern");
cstmt.setString(2, "prefix_index");
cstmt.setString(3, "true");
cstmt.execute();

String index_str = "CREATE INDEX oracle_index_extern ON texttable_intern(content) INDEXTYPE IS ctxsys.context PARAMETERS(' DATASTORE CTXSYS.DIRECT_DATASTORE
FILTER CTXSYS.INSO_FILTER format column text_typ
LEXER oracle_lexer_extern
WORDLIST oracle_wordlist_extern')";

stmt.execute(index_str);

Is it correct? If ja, what's wrong with the creating index? Can you tell me? (I use Oracle 9i under windows server 2003)

Thank you very much and greeting aus germany!

rabbit

Report message to a moderator

Previous Topic:	Text index build inso_filter problem
Next Topic:	SQL -Query on a long raw coulumn with text

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 11 15:34:59 CST 2024