Re: Debugging ODBC application

I echo this Rob's sentiments. SP's have really helped performance for our
VB and VBA Apps.


Thanks,

Mark


Mark Walter
Sr. Programmer/Analyst
Hanover Wire Cloth a div of CCX, Inc.
mwalter@hanoverwire.com
http://www.hanoverwire.com
717.637.3795 Ext.3040
/"\
\ /
 X
/ \




                    rob@dekko.com
                    Sent by:                   To:     midrange-l@midrange.com
                    midrange-l-admin@mi        cc:
                    drange.com                 Subject:     Re: Debugging ODBC 
application


                    11/06/2002 02:03 PM
                    Please respond to
                    midrange-l






This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
You think that your visual basic person can understand stored procedures
and result sets?  It will take some work on the RPG, (or COBOL, or ...)
developers part.

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin




ouuch@t-online.de
Sent by: midrange-l-admin@midrange.com
11/06/2002 02:06 PM
Please respond to midrange-l

        To:     midrange-l@midrange.com
        cc:
        Fax to:
        Subject:        Debugging ODBC application


Hello,

well, I'm still debugging this ODBC application. It is written/maintained
in VisualBasic by
another company and running on a Windows2000 server. It uses the Client
Access Express
ODBC driver.

We have heavy performance problems with this VB-app. With STRDBG and some
deep
digging I found that the app is doing a

          select * from vrosif where sistat='40' or sistat='41' or
sistat='43'

which returns about 1000 to 5000 records. In the QZDASOINIT joblog I see
several
thousand log entries like:

              1 record retrieved from vrosif.

Obviously, the VB-app does a fetch for every single record of the query.
This easily takes
30 seconds.

Doing the query manually through the tool SQLTHING I see  a few messages
like

             500 records retrieved from vrosif
             500 records retrieved from vrosif
             297 records retrieved from vrosif

This easily executes in 1-2 seconds!

I need to tell the VB-programmer how to achieve this (I have no knowledge
about VB and
ODBC programming).

Are there settings in the ODBC-driver for this record blocking or has this
to be programmed
in VB? Some sample lines of code would be nice..

Thanks in advance,

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


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