Page 1 of 1

How long does a temporary table last?

Posted: Wed Feb 20, 2008 9:21 am
by mikeeeeeeey
I'm using a temporary table to hold some results, and then output them by sorting to work with pagination, however it's not working properly. I'm just wondering how long a temporary table lasts i.e. when you load another page is it destroyed or still in memory?

Thanks for your help :)

Re: How long does a temporary table last?

Posted: Wed Feb 20, 2008 12:51 pm
by Weirdan
Temporary table is destroyed as soon as the db connection that created has been closed (that means 'when the page finished rendering' in the layman terms)