Creating temporary tables perl cgi dbi

Question

I have sql containing 8 table joins which takes time to fetch the data considering the amount of joins in the sql. I could create a temp table and simply the sql which might help speed up the data retrieval process.

i am trying to fetch the data using this sql in perl cgi dbi. Does it makes sense to create a temp table on a web application?

Answer 1

I have certainly used temp tables in SQL for a web application before. The web application part really doesn't have anything to do with it. Would a temp table make your SQL more efficient? You'd have to be a lot more specific with your question for us to tell.