No, it does not sound right. However, some of the techniques used to bind to
objects, and establish connections can materially impact performance. It
might be that a "new" (expensive) connection is being created each time
instead of leveraging the connection pool (that would account for a big
difference).
--
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.
________________________________
<dvmak_at_earthlink.net> wrote in message
news:Pp2m9.1408$lV3.122242_at_newsread1.prod.itd.earthlink.net...
> But 15 times slower for OleDB doesn't sound right...
>
> If it where that simple to use ODBC I would but we have corporate
standards
> and we need to use OleDB with the configuration set in a UDL file...
>
> I've tried both the Oracle and MS OleDB drivers and both are equally slow.
>
> "William (Bill) Vaughn" <billva_at_nwlink.com> wrote in message
> news:eR$ILsKaCHA.440_at_tkmsftngp11...
> > I have seen tests that show ODBC (what you call "DSN" connections) to be
> > faster in some cases than OLE DB connections. It really depends on what
> > you're doing, how you're doing it and which provider you're using (and
how
> > well that provider is written). There's nothing "wrong" with using what
> > works. In your case it sounds like ODBC might be a better choice. It's
> > faster in ADO.NET too (than the OleDb providers)... ;)
> >
> > --
> > 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.
> > ________________________________
> >
> >
> >
> > <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?
> > >
> > > Thanks
> > >
> > >
> >
> >
> >
>
>
Received on Mon Sep 30 2002 - 19:04:21 CDT
