Thanks for your help
How long does a temporary table last?
Moderator: General Moderators
- mikeeeeeeey
- Forum Contributor
- Posts: 130
- Joined: Mon Jul 03, 2006 4:17 am
- Location: Huddersfield, UK
How long does a temporary table last?
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
Thanks for your help
Re: How long does a temporary table last?
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)