Home » Server Options » Text & interMedia » why so slowly?
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
Previous Topic: Text index build inso_filter problem
Next Topic: SQL -Query on a long raw coulumn with text
Goto Forum:
  


Current Time: Thu Mar 28 10:43:01 CDT 2024