engine and collation should use the batch api. they are slow.