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.)
dbClearResult(res, ...)
res |
An object inheriting from DBIResult. |
... |
Other arguments passed on to methods. |
dbClearResult() returns TRUE, invisibly, for result sets obtained from
both dbSendQuery()
and dbSendStatement().
An attempt to close an already closed result set issues a warning
in both cases.
dbClearResult() frees all resources associated with retrieving
the result of a query or update operation.
The DBI backend can expect a call to dbClearResult() for each
dbSendQuery() or dbSendStatement() call.
Other DBIResult generics:
DBIResult-class,
dbBind(),
dbColumnInfo(),
dbFetch(),
dbGetInfo(),
dbGetRowCount(),
dbGetRowsAffected(),
dbGetStatement(),
dbHasCompleted(),
dbIsReadOnly(),
dbIsValid(),
dbQuoteIdentifier(),
dbQuoteLiteral(),
dbQuoteString(),
dbUnquoteIdentifier()
con <- dbConnect(RSQLite::SQLite(), ":memory:") rs <- dbSendQuery(con, "SELECT 1") print(dbFetch(rs)) dbClearResult(rs) dbDisconnect(con)
Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.