I need to make heavy statistical analysis to deliver some data to users. Currently, I catch the data from mysql and process them via
PHP arrays. However, mysql temporary tables are quite better (extremely more efficient and faster than PHP arrays; obviously due to their mechanism).
My tentative solution is to form a temporary table upon each request (i.e. connection) to import and process the data. However, I am not sure if there is a drawback for creating many temporary tables simultaneously?
Can this make problem for the mysql server? Or I can use it as an alternative to PHP arrays in numerous simultaneous requests?