Pooling is on by default.
--
William (Bill) Vaughn, Author, Trainer, Mentor
Microsoft Pacwest Regional Director
"ADO and ADO.NET Examples and Best Practices for VB Programmers--2nd
Edition" (ISBN: 1-893115-68-2)
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
________________________________
"Justin Cave" <jocave_at_yahoo.com> wrote in message
news:233b7a65.0209302031.5b788adc_at_posting.google.com...
> <dvmak_at_earthlink.net> wrote in message
news:<nJZl9.700$OB5.69309_at_newsread2.prod.itd.earthlink.net>...
> > Using a System DSN connection my asp pages are returning recorsets in <
1
> > sec. When I switch to Oledb (both OraOLEDB.Oracle.1 and MSDAORA.1) the
> > return time is > 15 sec.
> >
> > Using IIS server and tracing is off. Any hints on why the poor
performance?
>
> My first thought would be connection pooling. Since ODBC does
> connection pooling by default, I'd look to see whether you have
> enabled connection pooling in OLE DB.
>
> Justin Cave
Received on Tue Oct 01 2002 - 16:21:11 CDT
