| Oracle Text performance [message #141501] |
Mon, 10 October 2005 10:06  |
CrisDK
Messages: 1
Registered: October 2005
Location: Italy
|
Junior Member |
|
|
Hello, actually i'm working in a enterprise of online document consultation. I want to know the query performance for a indexed table of FILE_STORED pdf documents in various languages (also chinese) and containing text and images, filtered with the INSO_FILTER. The documents are 10000 for a disk space of 800 GB
What is the performance of a single word query like:
SELECT * from text_table WHERE CONTAINS(testo, 'oracle', 1) > 0;
and for a query like:
SELECT * from text_table WHERE CONTAINS(testo, 'in a database', 1) > 0;
Thanks
|
|
|
|
|
|
| Re: Oracle Text performance [message #142224 is a reply to message #141509] |
Thu, 13 October 2005 18:48  |
cybotto
Messages: 12
Registered: October 2005
|
Junior Member |
|
|
Oracle Text is text is fast, with 10.000 documents it will come up in fraction in a second, but 800 GB for 10.000 documents sound a little bit strange, 80 MB of text per document, nobody is going to read it. Never seen a book like this, it should weight too much to take it with you.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
