Home » Server Options » Text & interMedia » Proximity search Performance Oracle or JAVA
Proximity search Performance Oracle or JAVA [message #128925] Thu, 21 July 2005 04:57 Go to next message
karthi_dac2000
Messages: 1
Registered: July 2005
Junior Member
Dear friends,
We want to implement proximity search on a CLOB column with large text and huge number of records in an offline database.We want to know how feasible to use ORACLE CONTAINS and NEAR operator.Because We are supposed to use other conditions along with this proxumity also.
How will be the intermedia search performance compared to normal JAVA class searches in the table with its basic search APIs?
Are they any JAVA oracle intermedia API available and how feasible they are?
If to use oracle CONTAINS then,can we have additional conditions in where clause along with CONTAINS?
Please clarify at your earliest convienence.
Thanks in advance
Karthi

Re: Proximity search Performance Oracle or JAVA [message #129036 is a reply to message #128925] Thu, 21 July 2005 11:53 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Is it feasible? I'm not sure what kind of answer you are expecting here. The NEAR operator is a built-in feature of Oracle Text, so, yes, it is feasible. Whether or not the performance will be acceptable to you is another issue, but Oracle Text is highly optimized.

Yes, you can combine other search criteria with CONTAINS.
Previous Topic: File store
Next Topic: setting document Path in file system document store
Goto Forum:
  


Current Time: Thu Apr 17 11:58:54 CDT 2014

Total time taken to generate the page: 0.08154 seconds