Create indexes for an mpathsenser database — index

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. Because

Usage

index_db(db)

Arguments

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

Value

Returns TRUE invisibly, called for side effects.

Deprecation

Because participant_id, date, and time are now primary keys in the database, indexes are no longer needed.

Examples

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