Oracle Text CTX_DOC.snippet slow

Posted on 16th Feb 2014 07:03 pm by admin

I have a table (FILE_TABLE) that contains a blob column (ft_file) and I have created the following Oracle Text Index on that table/file column....
CREATE INDEX MYSCHEMA.FILE_TABLE_CON_IDX on MYSCHEMA.FILE_TABLE(ft_file) indextype is ctxsys.context parameters ('datastore CTXSYS.DEFAULT_DATASTORE SYNC (on commit)');

When I search the table using SQL Developer, the queries return real fast... 0.03 seconds to return 389 rows....
select ft.jsatfa_id , ft.file_id ft_id , l.description , ft.file_name , score(1) score1 --, CTX_DOC.snippet( -- 'FILE_TABLE_CON_IDX' -- , ft.file_id -- , 'test' -- , '' -- , '' -- ) snippet from FILE_TABLE ft , lov l where ft.file_type_lov_id = l.lov_id and (contains(ft.ft_file,'test',1) > 0)

when I uncomment the CTX_DOC.snippet function the time slows right down to 25+ seconds...

Am I doing something wrong or is this standard functionality with CTX_DOC.snippet?

Your Answer:

Login to answer

Other forums

Problem with php's rename function
So, i'm having a problem with the php rename function. Basically my script 'delete_user.php' attempt

values not being entered into table
hi. I;ve created a form, so that when a user enters data into it, it gets added to a table in a data

how to remove in php string display
My code is

$message="We're looking at developing our website.";

$body= "

keeps going back to index.html ???????
ok so i started making my site using mostly.html files now i have added a fair chunk of php. My inde

connect() succeeds but accept() does not?
Please help me with this problem. I'm working on a time-sensitive project where I'm using TCP socket

Onclick problem in Firefox
Hi,
I am using a . It doesn't seem to

Mysterious Timeouts
I've deployed a few simple AJAX-enabled web page to a local server that is accessed through the Inte

New to mysqli library - Multiple query problem
Greetings,

I am writing a batch program that executes 3 queries on a single page. Using mysql

preg_replace question
Hello!!

I hope someone can help me with preg_replace.

I load two tables from an extern

BSP Ext - tableView - Sort - NEWBIE
Hi,
I have been trying to get the sort to work. I have defined the column definitions by fillin