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?
session_destroy();
new to phpI have a simple login and am trying to write a logout.I set a $_SESSION var to 1 if they are logged in:if(isset($_POST['logname'])){ $UserArr = chk_lgn($_POST['logname'],$_POST['passwd']);
SAP BCS. BPS
Hi all,
login from external site
Hi my new experience begins, Now what i am trying to do is i make three pages, login.php logout.php index.php . Now if i will not give correct detail i can not see the index.php ,all working perfect
Ajax Issues - Update Panel / Timer. Intellisense doesn't know about them
Type 'System.Web.UI.ScriptManager' does not have a public property named 'UpdatePanel'.
Curl timeout breaks script
So im having difficulties with skipping timeout error in curlmy script calls different functions my problem is lets say if in function2 is curl timeout error it wont continue with function3 but kills
Getting PHP to ammended the selected in option field
Hey Guysthanks for everyones help so far. This site and its users are oozing awesomness.I am busy with a php script for editing users, of which 1 field is the TITLE of the person (mrs, miss, ms) and
Strip Slashes Help
I've got a script that i've downloaded of the net to edit multiple fields from my sql database, and works fine EXCEPT I want to add the strip slashes bit to it so it will save what I type in. However,
Could Someone Please Debug This?
I was wondering if someone could debug this script for me. I realize it's not the tidest script (and probably not the most efficiant in the world) but it was quite late when I wrote it and I can't be
Quick Syntax Question
Hi folks,I'm getting the following error: "unexpected T_LNUMBER". I'm trying to build a dynamic table in PHP it was working great until I attempted to include a java reference in one of my
Xacute search within SQL results
I have a query that is pulling data, and I want to return a specific value from the results of that query, so I'm using the following to do this:
