change from prepared statements to batch modifications