index_db: Create indexes for an mpathsenser database

In mpathsenser: Process and Analyse Data from m-Path Sense

Create indexes for an mpathsenser database

Description

Create indexes for an mpathsenser database on the participant_id, date, and a combination of these variable for all the tables in the database. This will speed up queries that use these variables in the WHERE clause.

Usage

index_db(db)

Arguments

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

Value

Returns TRUE invisibly, called for side effects.

Examples

## Not run: 
# First create a database in a temporary directory
db <- create_db(tempdir(), "mydb.db")

# Import some files
import(path = "path/to/jsons", db = db)

# Then index it to speed up the database
index_db(db)

## End(Not run)

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