Re: Records Buffered characteristic
From: Steve Corbett <p0070623_at_oxford-brookes.ac.uk>
Date: 13 Feb 1994 06:58:45 -0600
Message-ID: <CL5yKC.DEJ_at_uk.ac.brookes>
Date: 13 Feb 1994 06:58:45 -0600
Message-ID: <CL5yKC.DEJ_at_uk.ac.brookes>
smith_at_vnet.IBM.COM wrote:
: I have a query being performed in a block that seems slow to me.
: (It takes a couple seconds to display 17 rows of data from one table).
: I tried to change the Records Buffered default setting to 100, but this
: made no difference.
: I have all of the appropriate indexes, so does anyone know of any other
: form settings that I could fiddle with?
Forms 3 i presume?
IMHO the best i've found is set array to +1 of rows returned and
buffer to twice that of array.
Outside of that its down to indexes.
ps - check the 'where by' code on the block for optimization.
-- Steve Corbett. vvv [. .] p0070623_at_brookes.ac.uk --------o00-(_)-00o---------Received on Sun Feb 13 1994 - 13:58:45 CET