RE: ODBC performance with UPS Worldship CA ODBC Settings

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.
--
I'm not sure if a version thing.  It has been that way a while.
I have included a print of screen attached.
The default in CA ODBC is 32 bytes.  if your file has fields larger that 32
bytes you should up it to be larger than your largest field.  If you network
is good enough it should only make things transfer faster, if not you will
degrade (Same as with other option).  Make them large enough to get things
transfering faster.
Changing Network conditions will change performance of ODBC transfer.




-----Original Message-----
From: Dave Murvin [mailto:davem@drme.com]
Sent: Saturday, March 16, 2002 3:00 PM
To: midrange-l@midrange.com
Subject: RE: ODBC performance with UPS Worldship


At 05:02 AM 3/15/2002, Joe wrote:
>Yes - With CA ODBC you can also play with two pieces of data to "adjust
>performance"
>on the ODBC setup Server tab
>
>max field data returned box -  if you have fields larger than that setting
>you may want to up this number to match.

I did not see this box on the setup Server tab on my machines.  Is this a
version thing?


>Record Blocking size -  can up that is have large records being accessed
and
>will improve performance.

Did see this before, but have not tried it yet.  Will up the blocking from
the default 32.


Dave Murvin
DRM Enterprises, Inc.
davem@drme.com

_______________________________________________
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.

--
[ CA print.doc of type application/msword deleted ]