used transactions and commits, one for each hour