Jack,
Thanks for your time on this. Most revealing and useful for what I have
ahead of me
Kind regards from the UK.
Martin
-Original Message-
Sent: 04 October 2001 22:47
To: Multiple recipients of list ORACLE-L
Martin,
We use interMedia Text to index and query up to about
Excellent doc.
I just wonder if there are only cache related bugs on using interMedia.
Mario Alberto Ramos
[EMAIL PROTECTED] 04/10/01 16:47
Martin,
We use interMedia Text to index and query up to about 10-15 million CLOB
documents (up to 5KB each). We're on 8.1.6.0.0 under Win2k - 2 550MHz
Title: RE: Intermedia Performance Benchmarks anyone ?
Hi Martin,
I've had to implement intermedia in the past. with 1 million records intermedia will do the job in an acceptable amount of time.
However, when testing it I found that the more advanced features I used (fuzzy, etc
Martin,
We use interMedia Text to index and query up to about 10-15 million CLOB
documents (up to 5KB each). We're on 8.1.6.0.0 under Win2k - 2 550MHz CPUs,
2GB RAM, 18 36GB drives.
Because a domain index cannot be partitioned, we have the documents spread
across 5 tables (on 6 drives). One
*excellent* post. thanks.
Anyone out there put the indexes and tables on solid state disk? They
have ssd up to about 10G and higher, I hearjust curious, not trying
to invoke a global listserv discussion on how it can't work or wouldn't
be worth it, especially on microsoft platforms, etc.
Ross,
I disagree that interMedia Text is way too slow to scale. Our experience
has convinced us that I/O bottlenecks are the main performance killers with
large interMedia Text indexes. The problem is that it takes some experience
to find out how this special kind of index is structured (6 or
I looked into SSD, they are like $15-17k / gb. Very expensive.
And with Oracle buffering, I would expect the performance wouldn't be huge.
There were some solutions that were like $2500 for a 1 gb, but they were not
sharable between machines in a cluster.
-Original Message-
To: