Re: OleDB Poor performance

From: Justin Cave <jocave_at_yahoo.com>
Date: 30 Sep 2002 21:31:33 -0700
Message-ID: <233b7a65.0209302031.5b788adc@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 Mon Sep 30 2002 - 23:31:33 CDT