Re: Connection Pool at module level?

From:

"Alexander Nickolov" <agnickolov@mvps.org>

Newsgroups:

microsoft.public.vc.atl

Date:

Wed, 12 Dec 2007 09:15:54 -0800

Message-ID:

<uTboYJOPIHA.1168@TK2MSFTNGP02.phx.gbl>

OLE DB (not ADO - it's a simple wrapper on top of OLE DB)
already implements connection pooling for you.

--
=====================================
Alexander Nickolov
Microsoft MVP [VC], MCSD
email: agnickolov@mvps.org
MVP VC FAQ: http://vcfaq.mvps.org
=====================================

"kom18191" <martin.koppmann@macropool.com> wrote in message
news:b65a87d7-7273-4481-850d-096e9ab0fc83@e25g2000prg.googlegroups.com...

Hello,

I am developing a shell namespace extension (NSE) that visualizes
hierachical data from a SQL database directly in the shell.

My ATL object implements IPersistFolder2, IShellFolder2.
The shell (explorer.exe) sometimes creates instances very often (in
several threads) which is a performance hit because I have to open/
close a connection to the database frequently. Currently I open and
close the connection only when needed.

I not sure if OLE DB/ADO has build-in pooling at lover levels but I am
thinking about optimization.

Can I create global pool object, holding connections?
Where and when to instance?
When to destroy?

Thanks for your ideas and suggestions!

Martin