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?
Add code to enable passing of checkbox variable on login
Ok, I have a login page, but want to add a checkbox that when checked and successful login is made it passes the checkbox value (checked = "Yes" to the next page) which then loads password
Help =( !! Upload Pics [PHP script]
HelloI need help with a php script [MULTIPLE UPLOAD IMAGES] , where I want to add a feature (watermark the uploaded pictures) , thats mean its watermark & upload in the same time . look this
Save file by click
Hello. I'm not understand how to save file from page. I'd like make link to file with save ability.<?phpchdir('upload/');foreach (glob("*.*") as $filename) { $uploadfile =
Comment Mod System Effects all rows...
Sorry if its confusing but here is whats going on: I have a table in a database called comments and there are alot of entries there but can manually be marked flagged with a 1. nevermind how that is
filesize() returns 0
I have a socket program that runs in an infinite loop, listening for connections, in this socket I have a method, that is supposed to open a file and write to the file, but I am having issues. Each
Hi, explode and strstr.
Hi, I seem to be confused about the strstr function, eg. i have a string like:"a.b.c.d.e.f""a.b.c.d.e"I always want it to split at the second "." from the end, so
Request-URI Too Large
I have created a simple submit form for a mysql database that puts a piece of code into database.But if I want to put a document of any decent length, eg. 500 characters (I guess), I get the error
Calling a Procedure with IN & OUT Parameters
Hello,
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 ignored, rejected, or misunderstood in this forum. I'm surprised there isn't already any
Is there a quick way to do this?
Hi all,I need to create a mysql table from php that goes a little something like thisid, name, total, place1today, place1yersterdayhowever place1today and yersterday need to goto place2, place3 upto
