Norman Tindall
NormanTindall at zdisk.net
Fri Aug 18 14:26:21 EDT 2006
Hello, DF> So you are saying: DF> 1) There is a mechanism for cleaning up code DF> 2) This mechanism is not reliable DF> 3) Since databases have to assume clients are not reliable, they clean DF> up for them anyway DF> 4) Therefore we should not even try to clean up DF> I'm with you on points 1, 2, and 3, but I think point 4 is taking it a DF> bit too far... DF> Surely there must be *some* value in trying to clean up behind yourself, DF> sometimes? I am not sure if i understand right, but as i see the problem is to close connection or to return it to pool. Don`t know how about publisher and PSP, but in handler you always can at the end of processing, just before return apache.OK close connection , more better thing is to use 'try finnaly' and process all the stuff you need (selects,insert,..) in 'try' while conn.close() (or return to pool) if 'finnaly'. As i know 'finnaly' happens before 'return' statement even if 'return' in 'try'. I think the same can be easily done with Publisher and PSP. Am i right Graham? -- Best regards, Norman mailto:NormanTindall at zdisk.net
|