disabled autocommit and enabled transaction for more efficient data loading