Re: Performance of ODBC vs. other access methods

[richard@xxxxxxxxxxx]

Hello Dave, 

You're right I didn't address your question as specifically as you asked.

My comment still stands.  Tell us what you're trying to do and we'll be 
happy to provide more specific feedback with gory details as needed.  I 
don't think you'll hear too many fairy tales regarding ODBC drivers. Wrong 
forum for that :-) 

Also, the comparision which you are seeking is maybe too "ivory towerish" 
for the mortal man to comprehend. 

Maybe it's time to start testing with the ODBC and .Net data providers if 
there is truly something you're trying to accomplish :-)

You may be pleasantly surprised :-)

VB Express is FREE from the Microsoft Site. 

Regards,
Richard Schoen
RJS Software Systems Inc. 
"Providing Your....iNFORMATION NOW!"
Email: richard@xxxxxxxxxxxxxxx
Web Site: http://www.rjssoftware.com
Tel: (952) 898-3038
Fax: (952) 898-1781
Toll Free: (888) RJSSOFT

------------------------------

message: 8
date: Tue, 05 Sep 2006 16:07:38 -0700
from: "Dave Odom" <Dave.Odom@xxxxxxxxxxxx>
subject: Performance of ODBC vs. other access methods

Tom,

You wrote:

"I think it does answer your question, although it isn't an answer that
helps
much.

I interpret "it depends" to mean that there is no prevailing wisdom.  I
give
that answer a lot of credence because it was offered by several
luninaries
in the community.

Obviously, if I am interpreting incorrectly I hope someone will correct
me."

No, it doesn't answer the question at all as it doesn't speak to ODBC
vs.(means comparison) other access methods at all.   Instead, it speaks
to indexing strategies and what function I might be doing.

What I expected to here, as I've heard from others in the industry, is
based on each individual's experience, a comparison between access
methods (on the access methods mentioned and any others they'd like to
compare) from slowest to fastest; of course,  with the caveat of all
things being equal (of course my milage may vary depending on database
performance).   Then I expected, as is OFTEN done on this and other
forums,  example "war stories and fairy tales" of experiences with each
type of access method if they had them.   And, on and on, as has been
the characteristic with all the folks on here that are willing to share
their experiences. 

I think you are right about one thing... there is no prevailing wisdom
on this subject.  Perhaps I'm on the wrong forum.

Take care,

Dave