Re: Database speed issues

OSFA::One Size Fits All--a generic interface designed to access a wide
variety of engines.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
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.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
Between now and Nov. 6th 2006 you can sign up for a substantial discount.
Look for the "Early Bird" discount checkbox on the registration form...

"Rex the Strange" <roger.main@xxxxxxxxxxxxx> wrote in message
news:1159977774.373458.228550@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
OSFA?


William (Bill) Vaughn wrote:
There are at least three different "native" managed providers for Oracle.
Those sold by Microsoft, Oracle itself and DataDirect. Each has its
advantages and issues. In addition, you can also use generic (what I call
"OSFA") providers like ODBC and OLE DB that expose less native
functionality
but can actually be faster in some cases.
As I discuss in my books, it's not how fast you ask the question--execute
the query. It's how long it takes the server to answer the question that
governs performance. Most performance tests I've seen don't measure
anything
very well--and no, I didn't look at yours. The performance you seek might
be
gained by better indexes, smarter queries, properly handling server-side
compiled code and a dozen dozen other factors.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
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.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
Between now and Nov. 6th 2006 you can sign up for a substantial discount.
Look for the "Early Bird" discount checkbox on the registration form...

"Rex the Strange" <roger.main@xxxxxxxxxxxxx> wrote in message
news:1159914085.621484.273940@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Chris Mullins wrote:
Your test is a bit flawed.

First off, all of your methods are using ADO.Net. You're using a wide
variety of data providers, but they're all ADO.Net Data Providers.

You're never using the actual Oracle provided drivers for ADO.NET, so
you
don't have a good baseline to start from. The Microsoft provider for
Oracle
shouldn't be considered the ideal way to conenct to the Oracle
Database.
Sure, it's good enough for many things, but I would be willing to bet
it's
not nearly as tuned as (for example) the Sql Client provider for Sql
Server.

You're not factoring in database connection times (are you using
pooled
connections?), what's chached and what's not in the database, and a
number
of other items.

I would love to see your test done in a more rigorous way. To do this,
you'll need to be a bit more methodical though.

I have, personally, been involved in a number of "What database to we
buy,
and how do we connect to it?" decisions for very large applications.
I've
had excellent success with SqlClient connecting to Sql Server, and the
Oracle Provider(from Oracle, not Microsoft), connecting to Oracle.

OK. I'll cry uncle at this point. It seems that all I've managed to
demonstrate is that certain providers are faster than others. Allow me
to rephrase the question:

What do people think is the fastest way to connect to an Oracle
database?

rts.




.

Relevant Pages

  • Re: Enterprise Library - DataAccessApplicationBlock - MySql/DB2
    ... The fact that you set parameters differently for different providers isn't ... Oracle or Microsoft told me "We don't like the way you did that", ... ISDATE doesn't produce the same results in both Sql Server ... and Oracle both have a ton of specific features that others don't have. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Database speed issues
    ... Those sold by Microsoft, Oracle itself and DataDirect. ... "OSFA") providers like ODBC and OLE DB that expose less native functionality ... shouldn't be considered the ideal way to conenct to the Oracle Database. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Database speed issues
    ... There are at least three different "native" managed providers for Oracle. ... Those sold by Microsoft, Oracle itself and DataDirect. ... shouldn't be considered the ideal way to conenct to the Oracle Database. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: command line vs grid control
    ... all have classically trained DBAs in depth. ... Oracle from SQL Server, Sybase, or Informix OEM gives them instant ... Microsoft, which I know for a fact, just last week, was bringing ...
    (comp.databases.oracle.server)
  • Re: Database speed issues
    ... Those sold by Microsoft, Oracle itself and DataDirect. ... "OSFA") providers like ODBC and OLE DB that expose less native functionality ... shouldn't be considered the ideal way to conenct to the Oracle Database. ...
    (microsoft.public.dotnet.framework.adonet)
Loading