nolock
type: Item
instance of: R package
description: Provides a suite of tools that can assist in enhancing the processing efficiency of 'SQL' and 'R' scripts. - The 'libr_unused()' retrieves a vector of package names that are called within an 'R' script but are never actually used in the script. - The 'libr_used()' retrieves a vector of package names actively utilized within an 'R' script; packages loaded using 'library()' but not actually used in the script will not be included. - The 'libr_called()' retrieves a vector of all package names which are called within an 'R' script. - 'nolock()' appends 'WITH (nolock)' to all tables in 'SQL' queries. This facilitates reading from databases in scenarios where non-blocking reads are preferable, such as in high-transaction environments.
last update: 2023-11-15T00:00:00Z
software version identifier: 1.0.4
software version identifier: 1.1.0
author: Arkadiusz W. Pajda
maintained by: Arkadiusz W. Pajda
copyright license: GNU General Public License, version 3.0
imports: crayon
imports: rstudioapi
imports: utils
imports: stringr
imports: NCmisc
CRAN project: nolock
programmed in: R
MaRDI profile type: Software
description: Append 'WITH (NOLOCK)' to 'SQL' Queries, Get Packages in Active Script