This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C14D77.10391D30 Content-Type: text/plain; charset="iso-8859-1" David, Tis is a fact of life with any type if indexed file accessed by PowerHouse on MPE/iX (especially QTP). Add a 'SET FILE subfile OPEN EXCLUSIVE' after the ACCESS statement. Improves speed of non-indexed files as well. regards, +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ |Robert W.Mills (Systems Development Manager) | |Windsong Services, St. Mary Cray, ENGLAND | |Tel : +44 (0)1689 870622 x3005 | |Fax : +44 (0)1689 899026 | |Email: Robert.Mills@windsong-services.co.uk | +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ -----Original Message----- From: Maclary, David [mailto:dmaclary@wellington.com] Sent: 04 October 2001 20:17 To: 'powerh-l@lists.swau.edu' Subject: Indexed subfiles are S-L-O-W I'm wondering if anyone else has had the following experience... In Quiz, I can... > ACCESS subfile > SET REPORT LIMIT 999999 > GO and it's fast. If I create an indexed version of the subfile, and do the same thing... > ACCESS subfile > SET REPORT LIMIT 999999 > GO it talks a very long time. Anyone know why? And how to speed this up? Regards, David Maclary DMaclary@Wellington.Com = = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list: powerh-l@lists.swau.edu Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu Unsubscribe: "unsubscribe" in message body to powerh-l-request@lists.swau.edu http://lists.swau.edu/mailman/listinfo/powerh-l This list is closed, thus to post to the list you must be a subscriber. ------_=_NextPart_001_01C14D77.10391D30 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">RE: Indexed subfiles are S-L-O-W David,
Tis is a fact of life with any type if indexed file = accessed by PowerHouse on MPE/iX (especially QTP). Add a 'SET FILE = subfile OPEN EXCLUSIVE' after the ACCESS statement. Improves speed of = non-indexed files as well.
regards,
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
|Robert W.Mills (Systems Development Manager) = |
|Windsong Services, St. Mary Cray, = ENGLAND |
|Tel : +44 (0)1689 870622 = x3005 &= nbsp; |
|Fax : +44 (0)1689 = 899026 = |
|Email: Robert.Mills@windsong-services.co.uk = |
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-----Original Message-----
From: Maclary, David [mailto:dmaclary@wellington.com]
Sent: 04 October 2001 20:17
To: 'powerh-l@lists.swau.edu'
Subject: Indexed subfiles are S-L-O-W
I'm wondering if anyone else has had the following = experience...
In Quiz, I can...
> ACCESS subfile
> SET REPORT LIMIT 999999
> GO
and it's fast.If I create an indexed version of the subfile, and do = the same thing...
> ACCESS subfile
> SET REPORT LIMIT 999999
> GO
it talks a very long time.Anyone know why? And how to speed this up?
Regards,
David Maclary
DMaclary@Wellington.Com
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D = =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D
------_=_NextPart_001_01C14D77.10391D30--
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to = powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body = to powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you = must be a subscriber.