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?
Internal Server Error issues
This has been bothering me for weeks and I've been trying to solve it without asking for help, but eventually I had to give up Basically, I have a website that is based around manipulating photos with
newbie error
what is wrong with this code ? <html><body><?php$conn=odbc_connect('Towel','','');if (!$conn) {exit("Connection Failed: " . $conn);}$sql="SELECT *
Word filter problem
Hello,im trying to make a filter for words inputted in to my website but i want to store the swear word and the replacement for that word in a mysql db i have developed the code
RadioButtonList item spacing
I have a RadioButtonList and I can't put any spacing between the items. They are arranged vertically, and each one is right on top of the next.
VAT
how should I deal with VAT?if I have a product that costs £5.00 and VAT @ 17.5% (£0.875) the total cost of the product is £5.875.so how do people deal with VAT should I round up/down? are
Header redirect
Hello ive got a problem ive got form with its action set to itself.Code: <form id="formID" class="formular" method="post" action=""/>it then runs
Share admin accross websites
I'm using .net memberships and roles in one of my sites, but I need to be able to share logins and passwords for admins accross multiple sites that use a custom database for security. How would I go
Warning: session_start() [function.session-start]: Cann.....
hi, can someone help me with this? I keep getting this error....Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by ......I tried to upload my files
PHP and MySQL on intranet?
Is it possible to use both these on an intranet network?
Multi-image upload problems
Lets see if I can get some help on this one. Can anyone show me what I am doing wrong here. I'm just trying at this point to verify that the form inputs will work right. $max_img is set to 6. Here is
