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

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.