dbClearResult

0th

Percentile

Clear a result set

Frees all resources (local and remote) associated with a result set. In some cases (e.g., very large result sets) this can be a critical step to avoid exhausting resources (memory, file descriptors, etc.)

Usage
dbClearResult(res, ...)
Arguments
res
An object inheriting from DBIResult.
...
Other arguments passed on to methods.
Value

a logical indicating whether clearing the result set was successful or not.

See Also

Other DBIResult generics: DBIResult-class, SQL, dbBind, dbColumnInfo, dbFetch, dbGetInfo, dbGetRowCount, dbGetRowsAffected, dbGetStatement, dbHasCompleted, dbIsValid

Aliases
  • dbClearResult
Examples
library(DBI) con <- dbConnect(RSQLite::SQLite(), ":memory:") rs <- dbSendQuery(con, "SELECT 1") print(dbFetch(rs)) dbClearResult(rs) dbDisconnect(con)
Documentation reproduced from package DBI, version 0.5-1, License: LGPL (>= 2)

Community examples

Looks like there are no examples yet.