Searching large amounts of data in qtp

[Hans Hendriks]

-Mikael Olesen <mao@krifapost.dk> asked:

>Does anyone have some "shortcuts" when your searching
>large amounts of data in qtp/quiz? Especially I have
>problems with searching through one of our Image tables with
>7.5 mio. entries on our HP3000. It can take up to an hour!
>Does anyone have some tips etc. that can help me?

{plug alert!}
Suprtool can read and select data between 5 and 15 times faster than regular
serial reads, by replacing block/page i/o with MR;NOBUF (multi-record, no
buffered) access. This means that each disc access reads up to 50K of data.

Typically, you would front-end QTP with a Suprtool pre-pass as follows:

1) Build a large, empty subfile
2) Read the data with Suprtool, select the records you need to work with,
and write them to the subfile.
3) Access the subfile with Quiz or QTP, and work only with the subset of
qualified records.

Visit our website http://www.robelle.com (or http://www.suprtool.com :-) for
more information.

{/plug}

/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.