mysql TEMPORARY TABLE stored in ram?

I've developed a small c# application that uses quite intensive Database calculations. I am hosting my application in a shared hosting environment. I am getting :

mysql out of memory exception

I am using quite a lot of tem开发者_Python百科porary tables. Where are these tables stored? Could this be the reason for this error?

Thank you

---

Temporary tables are stored in memory, but if the temporary table gets too large it will get moved to the file system. Lots of temporary tables can definitely eat up a lot of memory and cause other kinds of performance problems as well. Also, large result sets can cause similar issues, so it's a good idea to check you're only fetching what you need and that the keys and indexes are correctly defined.