single select + multiple update (1 per tx) : 65.648 seconds single select + multiple update (100 per tx) : 18.732 seconds single update and java udf : 10.351 seconds multiple select first 50 + multiple update : 106.957 seconds