Forum OpenACS Q&A: Response to Beginners Question on Processes/ Database Pools / Threads

When I take handles and do NOT release them, e.g. because of wrong program code, what happens to them?
They get released (placed back in the pool) when the page where you allocated them goes out of scope (stops executing). So you won't run out of handles and then crash or something; the server won't lose handles that easily. But if you have a lot of such pages running, then they'll be competing for handles and you'll get a lot of stalling on your server. Better to use the OACS4 db_* functions, which grab a handle internally and release it as soon as they finish processing a query.