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

asp authentication problem
Hello all, I want to use the asp authentication (from asp.net configuration) in my web site. there

noob cURL help
I have a pretty basic form that I need to cURL post to a file in my includes folder (includes/login.

Help with php code
Hello, can anyone tell me why this php word trap fails to work,
and the trigger words get blow r

Display a default image
I am trying to display generic image for items that don't have one, but I can't get it to display.

help with multi-update
Now sure how to ask this really....
10g database if that matters.

I have a customer

Loops and Classes
I am making a template system and everything seems to be going well up until I have to loop in a var

How to ask a regex question?
Hi, I thought I'd share some of my insight after seeing too many bad questions that either get ignor

am I using this for loop correctly
Dear buddies!

Right now I am generating a report with some details for all the dealers.

First root of a number
Hi,

I can't find any function in php to give me the first root of a number.
Is there any

Forgot password won't work
My forgot password thing is not working properly. It is giving me this errorMailbox unavailable. The