How long does a temporary table last?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
mikeeeeeeey
Forum Contributor
Posts: 130
Joined: Mon Jul 03, 2006 4:17 am
Location: Huddersfield, UK

How long does a temporary table last?

Post 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 :)
User avatar
Weirdan
Moderator
Posts: 5978
Joined: Mon Nov 03, 2003 6:13 pm
Location: Odessa, Ukraine

Re: How long does a temporary table last?

Post 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)
Post Reply