| Subject | how many time keep a connection before to "recycle" it ? |
|---|---|
| Author | nathanelrick |
| Post date | 2012-03-12T19:15:42Z |
hello,
how many time to keep a connection before to "recycle" it ? 1 hours? 6 hours? 24 hours ? undefinitively ?
same for my readonly read commited transaction... how many time to keep it active before to recycle (commit) it ?
and finally same for my readonly read commited statement (prepared SQL)
just to have you opinion ... because for exemple in webserver it's common to recycle all the process every 24 hours
how many time to keep a connection before to "recycle" it ? 1 hours? 6 hours? 24 hours ? undefinitively ?
same for my readonly read commited transaction... how many time to keep it active before to recycle (commit) it ?
and finally same for my readonly read commited statement (prepared SQL)
just to have you opinion ... because for exemple in webserver it's common to recycle all the process every 24 hours