Home » Developer & Programmer » Forms » number of record buffered ??????
number of record buffered ?????? [message #217321] Thu, 01 February 2007 12:28 Go to next message
m_arafa
Messages: 36
Registered: June 2006
Member
hi,

emp table contains 100 records

properies in emp block ....
number of record buffered 50
number of record displayed 10
quary array size 0


how many network rounds trip will be made to the server

a.1
b.2
c.10
d.50
e.100

answer: c

why??
==============================================
Re: number of record buffered ?????? [message #217944 is a reply to message #217321] Tue, 06 February 2007 03:10 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Another one of these stupid rote learning questions.

The 'query array size' is probably the factor. Read the documentation as it talks about what happens when it is set to 1. Setting it to 0 probably makes the fetches equal the number of records displayed.

Get a network sniffer, run a form, read the output, and count the round trips.

David
Previous Topic: font name in oracle forms10g
Next Topic: a problem with forms builder 10g
Goto Forum:
  


Current Time: Thu Dec 05 19:52:51 CST 2024