|
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
|