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

need help to creat database
Hello Team, please guys i am stuck from three days with paypal issue for IPN but no luck yet now i w

Odd or Even
Inside of a while loop I need to echo several rows of info...easy enough.

In the loop (for th

Probably a simple error...
I'm getting the error -- Parse error: syntax error, unexpected '{' in /home/content/c/s/t/csteffen24

weeks in a year
hi,

i found this snippet on php.net
QuoteFor the week number for weeks starting on Sunday:

Why do I get this error?
Error:

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or

Passing Variables
What I'm wanting to do is when the user clicks on Arenas it will know the name of the country it's w

DataTable Help Required
Hi all I am creating an app that utilises and MS Access back end and queries it quite a bit at vario

Different payment methods with different cross company requirements in F110
We are implementing SAP in a company in the shipping industry. They have the following requirement:<

Form submissing with PHP and JQuery/Ajax
I have searched everywhere, but cannot find a solution for this... I have worked all day trying to g

Images outside webroot
Im hopeing someone can help me with this because i cant figure it out.I have setup an ASP.NET websit