dropBioassayIndex {bioassayR} | R Documentation

## Remove index from a bioassayR database

### Description

Indexing a bioassayR database before performing queries will drastically improve query performance. However, it will also slow down loading large amounts of additional data. Therefore, it may be necessary to use this index to remove an index from a database before adding large quantities of data. Afterwards, the index can be re-generated using the `addBioassayIndex` function.

### Usage

    dropBioassayIndex(database)

### Arguments

`database` | A `BioassayDB` database to have the index removed.

### Author(s)

Tyler Backman

### Examples

    ## create test database
    library(bioassayR)
    filename <- tempfile()
    mydb <- newBioassayDB(filename, indexed=TRUE)

    ## remove database index
    dropBioassayIndex(mydb)

    ## load new data into database here

    ## reactivate index
    addBioassayIndex(mydb)

    ## close and delete test database
    disconnectBioassayDB(mydb)
    unlink(filename)

[Package bioassayR version 1.32.1 Index]