using batch insert statements with batch size 1000 for transcript profiles