RE: MIDRANGE-L Digest, Vol 5, Issue 1682

 <snip>
index the hell out of your database 
based on your average query types 
</snip>

If only I could...in our shop our main software package is a 3rd party
software & the mandate is to not change or customize the base product
unless it's just a "have-to" case.  Since adding indexes can sometimes
have adverse effects on some base code it's just not always a viable
solution (not arguing at all..In fact I support index usage
whole-heartedly...) unfortunately some of us have to march to the beat
of someone else's drum =(


Thanks,
Tommy Holden


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
richard@xxxxxxxxxxx
Sent: Tuesday, September 05, 2006 10:33 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: MIDRANGE-L Digest, Vol 5, Issue 1682

Actually my prevailing wisdom on SQL and ODBC in general is to look at
the 
types of queries you will be running, index the hell out of your
database 
based on your average query types and test, test, test to make sure you 
didn't forget something that will kill your system when you fire off a 
quick lookup query over a 10 million record file with a selection field 
that you thought was indexed, but isn't. 

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: 2
date: Tue, 5 Sep 2006 13:01:51 -0700
from: "Tom Jedrzejewicz" <tomjedrz@xxxxxxxxx>
subject: Re: Performance of ODBC vs. other access methods

On 9/5/06, Dave Odom <Dave.Odom@xxxxxxxxxxxx> wrote:

...

Yes, very aware of all the "depends" but that doesn't answer my basic

questions which were:

"What's the prevailing wisdom backed up by real world experience when
using ODBC from whatever tool or programming language to access
DB2/400 or ORACLE versus using some other remote or distributed access
method
such as DRDA, calls to stored procedures or API calls?   I've been
told that ODBC is a good performer but have my doubts.

What's your experience show vs Ivory Tower tests?"

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.

Take care ...