Kbase P176713: Is the number of records packed into a network message affected by the use of the NO-LOCK qualifier
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/13/2010 |
|
Status: Verified
GOAL:
Is the number of records packed into a network message affected by the use of the NO-LOCK qualifier in a query?
GOAL:
How many records are returned in a network message sent by the server to the client?
GOAL:
Does -Mm affect the number of records a server will pack into a network message to be sent to a client?
FIX:
The -Mm parameter is used to specify the standard message buffer size in bytes. OpenEdge uses message buffers to move records between servers and remote clients.
The number of records that get packed into a message buffer depends on they type of query run and the size of the records.
When running a query using the NO-LOCK qualifier, the first record is packed into a message buffer and sent to the client. For the remaining records, a message buffer will be packed with as many records as it can fit. The number of records that will fit in the message buffer depends on the size of the records and the value of -Mm.
Running a query that utilizes any other type of lock other than NO-LOCK, will result in only one record per message buffer sent to the client, regardless of the -Mm startup parameter value. This is done by design, so as to minimize the number of records locked at any one time.