index_db {mpathsenser} | R Documentation |
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)
[Package mpathsenser version 1.2.3 Index]