Searching large amounts of data in qtp

[Hans Hendriks]

Georgia Miller <georgia_miller@gfps.k12.mt.us> said: 

>............................... When we purchased 
>Omnidex, we  compared Omnidex to Supertool and chose Omnidex.  It works very 
>well for us in the HP3000, MPEix, Image, Powerhouse environment.  Omnidex 
>uses the Image TPI (3rd Party Indexing) and also has an agreement with 
>COGNOS.
>
>Sorry if this is a plug for Omnidex - just sharing what works for us.

Georgia is absolutely correct that Omnidex is a wonderful product, and we use it extensively for our in-house systems. However, its important to discern between Omnidex and Suprtool......

Omnidex is an indexing enhancement product for Image. It works around Image's limitation of only ever allowing indexed access via 1 key, with the full key value. Omnidex stores additional index information in its own data structures (in the same, or in a separate database), and then resolves "complex" queries into "simple" Image keyed accesses. The advantage is powerful and flexible retrieval functionality. The cost is the overhead of maintaining multiple index structures at update time. Effectively, you're moving the processing overhead from "read time" to "write time". This makes sense if you have fairly static data, and need fast on-line retrievals.

Suprtool is primarily a serial read tool. It excels at reading large amounts of data at high speed, in order to select a subset of records that it passes on to other applications for further processing. It doesn't rely on any special data structures (though it can do keyed access, either via Image or Omnidex (or Superdex) keys.) Suprtool reduces the overhead of your serial access, without any cost at update time. (Also, its price is a fraction of Omnidex's :-)

So the two products are really designed to address different problems. Do you need fast on-line access to your data? Or do you need to speed up serial batch processing?

/Hans
|----------------------------------------------------------------------
| Hans Hendriks                 Robelle Consulting
| http://www.robelle.com/~hans
| hans@robelle.com        personal: hans@cheerful.com




= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.