write raw data to redis and then move it to sql db with just a single worker

[hsegnitz]

use transactions for faster writes and less pk gaps. make id columns smaller again this will need a series of load tests first.