RE: ODBC Perfomance issue

As you say "brings to its knees", I would speculate that you've got a badly
structured, poorly tuned SQL statement that is causing the big hit.  Can you
give us more info, such as OS version, model number, and perhaps more detail
about the SQL involved? 

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



-----Original Message-----
From: g man [mailto:g.man2000@lycos.com]
Sent: Tuesday, January 28, 2003 12:07 PM
To: Midrange Systems Technical Discussion
Subject: ODBC Perfomance issue



  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.