There are no such benchmarks available in any documentation or online, but you can do it by yourself using eneperf utility provided by Endeca.
Install both MDEX version on separate machine and try it on similar set of data.
Also go through Release notes and MDEX Migration Guide to get information on any fix made which might improve performance.
Performance is inextricably linked to the application index I'm afraid, so there isn't any simple magic number. Main features I've found that impact performance are:
- number of records in the index
- size of records
- partial update usage
- wildcard usage
- large number of dimensions/values
Hardware factors include:
- CPU speed
- Disk type (I/O plays a big part on cache flush from baseline/partial etc.)
Your best bet is to contact sales or consulting and they can assist with any hardware sizing (assuming this is for hardware sizing).
Yes, there are performance enhancements in 6.3 - specifically around partial updates and continuous queries. You can find general notes here: http://www.oracle.com/ocom/groups/public/@otn/documents/digitalasset/1704701.pdf . The big one is cache warming - I've not used this yet, but it should mitigate the issue of slower performance directly after a partial update (which occurred due to the cache being cleared, a necessary evil given the data has been updated).