RE: Optimizing iSeries acess with VB6 (was accessing ...)

["Metz, Zak" <Zak_Metz@xxxxxx>]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
I'm curious if this would apply to net.data also...I know I need some better
indices, but my code is very dynamic so it's difficult to work backwards to
add what it "needs."

-----Original Message-----
From: Adam Lang [mailto:aalang@rutgersinsurance.com]
Sent: Tuesday, August 13, 2002 10:19 AM
To: midrange-l@midrange.com
Subject: Optimizing iSeries acess with VB6 (was accessing ...)


Oh, please elaborate on this.

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
----- Original Message -----
From: "Vernon Hamberg" <vhamberg@attbi.com>
To: <midrange-l@midrange.com>
Sent: Tuesday, August 13, 2002 12:04 AM
Subject: Re: access as/400 database files w/Visual Basic 6


> Performance with ODBC and OLE/DB is completely dependent on good use of
> indexes, so turn on STRDBG in the serving job QZDASOINIT. V5R1 version of
> ODBC driver lets you turn this on from the data source definition. Then
you
> can get index recommendations. You CAN get excellent response from ODBC
> with good indexes and larger block sizes, etc. Likewise with OLE/DB. Check
> the Knowledge Base.




_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.
NOTICE:  This E-mail may contain confidential information.  If you are not
the addressee or the intended recipient please do not read this E-mail and
please immediately delete this e-mail message and any attachments from your
workstation or network mail system. If you are the addressee or the intended
recipient and you save or print a copy of this E-mail, please place it in an
appropriate file, depending on whether confidential information is contained
in the message.