Re: Forms4.5: LAST_RECORD/Performance
Date: 1995/06/29
Message-ID: <jalford.256.00B25FEA_at_immcms1.redstone.army.mil>#1/1
In article <3ssvae$i65_at_earth.superlink.net> raiden_at_mars.superlink.net writes:
>From: raiden_at_mars.superlink.net
>Subject: Re: Forms4.5: LAST_RECORD/Performance
>Date: 29 Jun 1995 01:23:26 GMT
>> multipro_at_ix.netcom.com (Michael Irene) writes:
>> I'm trying to add a "Goto Last Record" feature to a form containing a
>> multi-record block. For large queries, using the LAST_RECORD function
>If you want, you can specify the "all_records" clause in the execute_query call. This way, all the
>records will be fetched at the time of query.
>Just a suggestion.
The "all_records" solution is not recommended if you have large queries, it's seems worse than the last_record. I've tried numerous ways to solve the last_record performance problem with no luck :-(
- huckleberry