db_vacuum: Functions to vacuum, analyse, and optimise database tables.

In skgrange/databaser: Tools to Keep Database Interaction Easy and Consistent

Functions to vacuum, analyse, and optimise database tables.

Description

The PostgreSQL statement uses VACUUM (VERBOSE), the MySQL statement uses OPTIMIZE, and the SQLite statement uses VACUUM and the table argument is not used.

Usage

db_vacuum(con, table = NA, verbose = FALSE)

db_optimise(con, table = NA, verbose = FALSE)

Arguments

con	Database connection.
table	Database table.
verbose	Should the function give messages?

Value

Invisible tibble.

Author(s)

Stuart K. Grange

Examples

## Not run: 

db_vacuum(con, "model_data")
db_optimise(con, "air_quality_data")


## End(Not run)

skgrange/databaser documentation built on Sept. 26, 2024, 8:30 p.m.