my procedure contains three four temporary tables and using without creation of table structure

for ex:

Select * into #td from transsactions

Transactions tables contains huge data. Like that i am using three temporary tables without creating the table structure.

while calling with procedure sometimes iam getting performance issues. execution getting delayed. it is working when i rename the procedure for some days.