mpathsenser (version 1.2.3)

index_db: 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)

Value

Returns TRUE invisibly, called for side effects.

Arguments

db

A database connection to an m-Path Sense database.

Examples

if (FALSE) {
# 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)
}