5 ms·

I see what it's doing but I don't really see what the benefit is. Maybe a comparison to what previously had to be done would help me? Would you have to make the

by tgb 6y ago

I see what it's doing but I don't really see what the benefit is. Maybe a comparison to what previously had to be done would help me? Would you have to make the 'daily' table in a separate step and then UPDATE using that?

nicoburns 6y ago
Previously you would have to SELECT and then UPDATE in separate queries, meaning that the data is round tripping to your application server and back again. Edit: Or use subqueries apparently.
- enedil 6y ago
  This is sqlite, you typically don't have a server.