Re: ODBC Perfomance issue

Hello,

we currently have several big projects that use ODBC - and we had lots and
lots of performance problems.
Not so much on the AS/400, but on the application running on the pc
server.. Very simple SQL-statements and
only 2 or 3 files on the AS/400 that were used (and all less than 20.000
records).

We are now switching to OLE-DB, which, on the first try, seems to be 5
times faster than ODBC.  Updates that
took about 200ms through ODBC where done in about 40ms with OLE-DB. I know
that isn't accurate, just some
stopwatch checking, but factor 5 (for minimal program changes) seems to be
promising.

We will be running some more in-depth test in the near future..

Regards,

Oliver




                                                                                
                                                                    
                      "g man" <g.man2000@lycos.com>                             
                                                                    
                      Sent by:                                                  
        To:       "Midrange Systems Technical Discussion"           
                      
midrange-l-bounces+oliver.wenzel=cibavision.novartis.com@m         
<midrange-l@midrange.com>                                  
                      idrange.com                                               
        cc:                                                         
                                                                                
        Subject:  ODBC Perfomance issue                             
                                                                                
                                                                    
                      28.01.03 19:07                                            
                                                                    
                      Please respond to Midrange Systems Technical Discussion   
                                                                    
                                                                                
                                                                    
                                                                                
                                                                    





  I am working with a 'legacy' type application that interfaces a VB
application (using ODBC) with an AS/400 system file with a trigger on it to
process the data to update yet another set of files.

The problem being experienced is a huge performance hit on the AS/400 - I
had heard that ODBC was slow but bringing the system to it's knees is
another issue.

Is there any tuning I could investigate to make this more efficient..or is
there a way to direct the VB job as it signs on to the 400 to a separate
subsystem or some such..

I'd appreciate the help..

Girish



_____________________________________________________________
Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year.
http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus
_______________________________________________
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/mailman/listinfo.cgi/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.