Searching large amounts of data in qtp

Chris.Sharman@ccagroup.co.uk Chris.Sharman@ccagroup.co.uk
Wed, 06 May 1998 14:59:31 GMT


>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?

The question's a bit sparse on necessary detail, but some general pointers:

Quiz may be faster than QTP (less locking).
Avoid sorting.
Use choose rather than select where possible.
Consider a nice fast OpenVMS Alpha machine ;-)
______________________________________________________________________
Chris Sharman			Chris.Sharman@CCAgroup.co.uk
CCA Stationery Ltd, Eastway, Fulwood, Preston, Lancashire, PR2 9WS.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.