vacuum_db: Vacuum a database
In mpathsenser: Process and Analyse Data from m-Path Sense

vacuum_db

R Documentation

Vacuum a database

Description

This is a convenience function that calls the VACUUM command on a database. This command will rebuild the database file, repacking it into a minimal amount of disk space.

Usage

vacuum_db(db)

Arguments

`db`	A database connection to an m-Path Sense database.

Value

a scalar numeric that specifies the number of rows affected by the vacuum.

Examples

# Create a database in a temporary directory
db <- create_db(tempdir(), "mydb.db")

# Assuming that we have imported some data into the database, we can vacuum it
vacuum_db(db)

# Cleanup
close_db(db)
file.remove(file.path(tempdir(), "mydb.db"))

mpathsenser documentation built on May 29, 2024, 9:11 a.m.