Row-Returning vs batch Returning

  • Thread starter Thread starter ac
  • Start date Start date
A

ac

Hi,

Some fundamental question which i came across many times, what are the
different?

thanks
ac.
 
The differences are more apparent in Client/Server than in File Server
databases. Returning 1 row of data uses less network resources.

Perhaps you meant to ask about row-level locking as opposed to page locking.
In that case Page locking is faster than row-level locking and should be
used when there are no record locking problems. When there are record
locking conflicts use row-level locking or for larger updates lock all
records in the table.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Thank You for the enlightenment.
cheers,
ac.
Arvin Meyer said:
The differences are more apparent in Client/Server than in File Server
databases. Returning 1 row of data uses less network resources.

Perhaps you meant to ask about row-level locking as opposed to page locking.
In that case Page locking is faster than row-level locking and should be
used when there are no record locking problems. When there are record
locking conflicts use row-level locking or for larger updates lock all
records in the table.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
Click to expand...
 
Back
Top