There exists a great difference in performance between creating a temp table to store the information vs using associative arrays.

And also consider multiple parallel connections in a high traffic database creating so many temp tables :(