i wanted the prepare statement outside the loop because i believe it is quicker that way? I have millions of records