Thanks amedico. I notice the improvement from using 'fetchrow_hashref'. Thanks. I'm currently 'having a go' at the 2nd suggestion, to see how it affects the entire scheme. Thanks a lot