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?
how to remove in php string display
My code is$message="We're looking at developing our website.";$body= "My message is,\n\n\n\n\t\t\t".$message";echo $body;I get result We\'re looking at developing our
Extracting Long text from message class with parameters
Hi,
Coding question?
Hey guys, I have a quick question. If I want to make a way for people to pay for health in my game, how would I go about coding that? Would be like this?Code: ($purchace = 1000000) ==
strptime() equivalent for php4 ?!
Greetings!this is my first post, thank you in advance for your replies. Well, the title says it all, is there an equivalent of the function strptime() for php4 ? I want to parse a timestamp like this
Formatting echo from database
So I have a database that stores First and last names, then echos them back to a website, as of now the entire first and last name echos back (John Smith) I want the last name to just display the
Undefined offset when using a flat file with pipe symbols
Hi, I've got a flat file/text file which I'm currently using as a member database for my site (not advisable I know.. but still learning here).In a section of code I need to separate the fields to
Polymorphism
Was wondering if someone could explain this a little better to me. I had always assumed that it had to do with method overloading or overriding(through inheritence). The following wikipedia entry
code help - pagination
Hi all, I have this code, basically a user logs into my site and they get this page. The problem I have is that the pagination isn't working, and I can figure out why. I dont get any errors.Can you
word wrap in emails help needed
Hello, I understand how wordwrap works in php and have used it well before. However when I used wordwrap on a variable that is going to be emailed it puts the line breaks in well before it should.
Help building / using array
First - this is a cross-posting, if this is wrong I apologise! What started out as a MySQL query question (original post http://www.phpfreaks.com/forums/index.php/topic,273323.0.html) has become a PHP