Indexed subfiles are S-L-O-W
Martin McDonough
MartinM@Rosebys.com
Fri, 5 Oct 2001 09:17:42 +0100
If your on the hp3000...
I've only had this problem linking to indexed subfiles and only when doing
it online
Try QUIZ INFO="NOBREAKSET"
Access ....
> -----Original Message-----
> From: Maclary, David [SMTP: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.