Learn R Programming

timeseriesdb (version 0.4.1)

storeMetaChunkWise: Store Meta Information Chunk Wise to Avoid Memory Problem

Description

FUNCTION DEPRECATED. This function is a wrapper around updateMetaInformation. It is used to split large environments of meta info to avoid memory limitations. This function uses INSERT INTO instead of the more convenient dbWritetable for performance reasons. DO NOT USE THIS FUNCTIONS IN LOOPS OR LAPPLY! This function can handle a set of time series on its own and is much faster than looping over a list. Non-unique primary keys are overwritten !

Usage

storeMetaChunkWise(meta_envir, con, schema = "timeseries",
  tbl = "meta_data_unlocalized", keys = NULL, chunksize = NULL,
  quiet = T)

Arguments

meta_envir

object of class meta_env. Most likely generated by addMetaInformation

con

a PostgreSQL connection object

schema

character name of the schema to write to. Defaults to 'timeseries'.

tbl

character name of the meta information table to write to. Defaults to 'meta_data_unlocalized'.

keys

character vector of time series. If specified only the selected meta information is stored. Defaults to NULL which stores all meta information records in the environment.

chunksize

integer number of chunks. Defaults to NULL which automatically choose chunks based on Cstack size.

quiet

logical should the update function be quiet? Defaults to TRUE.