what are the risk in a website when I using temporary tables to fetch data?

[senthilnath]

In a website a pdf will be generated according to the product id.for that i am using function with temporary tables.
my question is that when many of them hit the website how the pdf will active according to the temporary table?

[Frinavale]

Are you creating a temporary table in your database?

You could consider creating a DataTable in memory instead...that way the table is just created when it is needed and it is destroyed after you're finished with it.

-Frinny