dbCreateIndexes {sendigR} | R Documentation |
Create indexes in SEND database
Description
Create a set of indexes on the tables in an SQLite SEND database to optimize performance of extraction of data from the different functions in the package.
Usage
dbCreateIndexes(dbToken, replaceExisting = FALSE)
Arguments
dbToken |
Mandatory |
replaceExisting |
Mandatory, character |
Details
All the indexes are named <domain name>_sendigr_<nn>
- .e.g.
TS_sendigr_01
.
If any additional indexes are manually created in the database, avoid to
include 'sendigr' in the name, because all existing indexes with that
included in the name will be initially deleted when execution the function
with replaceExisting = TRUE
.
It's recommended to wait with the creation of the indexes until the major
amount of studies to be loaded in to the database are loaded.
The database must be an SQLite database - no other types of databases are supported by this function.
Value
No return value, called for side effects
Examples
## Not run:
createAllIndexes(myDbToken)
## End(Not run)