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_01C14D14.5E816EB0 Content-Type: text/plain; charset="iso-8859-1" I never noticed a difference in speed when reading (on VMS platform). What platform are you on? > -----Original Message----- > From: Maclary, David [mailto:dmaclary@wellington.com] > Sent: Thursday, October 04, 2001 12:17 PM > 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_01C14D14.5E816EB0 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 I never noticed a difference in speed when
reading (on VMS platform). What platform are you = on?> -----Original Message-----
------_=_NextPart_001_01C14D14.5E816EB0--
> From: Maclary, David [mailto:dmaclary@wellington.com]
> Sent: Thursday, October 04, 2001 12:17 = PM
> 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
> 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.
>