Which one of the following combinations of property settings for the Orders block will provide the fastest response time

The Orders table in the database contains several thousand records. There is a block in the Orders form that is based on the ORDERS table and displays one record. The block is ordered by the Order_Date in descending order, because order entry clerks usually must access only the most recent orders. Which one of the following combinations of property settings for the Orders block will provide the fastest response time before a record appears in the block upon executing a query?

The Orders table in the database contains several thousand records. There is a block in the Orders form that is based on the ORDERS table and displays one record. The block is ordered by the Order_Date in descending order, because order entry clerks usually must access only the most recent orders. Which one of the following combinations of property settings for the Orders block will provide the fastest response time before a record appears in the block upon executing a query?

A.
Query Array Size: 0
Number of Records Buffered: 0
Query All Records: Yes

B.
Query Array Size: 1000
Number of Records Buffered: 0
Query All Records: Yes

C.
Query Array Size: 1000
Number of Records Buffered: 0
Query All Records: No

D.
Query Array Size: 0
Number of Records Buffered: 1000
Query All Records: No

E.
Query Array Size: 0
Number of Records Buffered: 1000
Query All Records: Yes



Leave a Reply 0

Your email address will not be published. Required fields are marked *