gistfile1.txt

const keyHash = (params) => {
  let hash = '';
  _.each(params, (val, key) => {
    hash+=`${key}:${val}`;
  });
  return hash;
}

const execQueryCached = async (params) => {
  const hash = keyHash(params);
  if(await redis.existAsync(hash)) return await redis.getAsync(hash);
  const result = await execQuery(params);
  return await redis.setAsync(hash, result).then(()=>result);
}

this one is to add a "query cache" in redis