Re: Slow PL SQL command LAST_RECORD
From: Steve Cosner <stevec_at_zimmer.csufresno.edu>
Date: 20 Apr 1999 15:08:48 GMT
Message-ID: <7fi5a0$4tb$1_at_nntp.csufresno.edu>
http://members.aol.com/stevec5088
Downloadable Quick Access utility form: Display and update any table. Received on Tue Apr 20 1999 - 17:08:48 CEST
Date: 20 Apr 1999 15:08:48 GMT
Message-ID: <7fi5a0$4tb$1_at_nntp.csufresno.edu>
In article <371B1993.5D8B7BF9_at_ttu.ee>, Svetlana Pelesheva <pele_at_ttu.ee> wrote:
>Hi,
>How to go faster (than by LAST_RECORD) to the last record of a table.
>
>Thanks for the help.
Last_Record causes the form to fetch all rows from the select statement into your form. If there are hundreds or thousands of rows, all of them have be to fetched, and this takes a long time.
To get to the record you want, either modify the where clause to get fewer records, or invert the order by so the last record comes up first.
Steve Cosner
http://members.aol.com/stevec5088
Downloadable Quick Access utility form: Display and update any table. Received on Tue Apr 20 1999 - 17:08:48 CEST