buildCompactKeepersSQL
buildCompactKeepersSQL(
tableName,cutoffT,targetOldRows):string
Defined in: db/store.ts:113
Build SQL to create a temp table of “keeper” t values from old data. Uses NTILE to divide old rows into equal-count buckets, keeping the earliest t (MIN) from each bucket as the representative point.
Parameters
Section titled “Parameters”tableName
Section titled “tableName”string
cutoffT
Section titled “cutoffT”number
targetOldRows
Section titled “targetOldRows”number
Returns
Section titled “Returns”string