Row-Returning vs batch Returning

[ac]

Hi,

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

thanks
ac.

 

[Arvin Meyer]

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

 

[ac]

Thank You for the enlightenment.
cheers,
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