RE: ODBC Perfomance issue

["Walden H. Leverich III" <WaldenL@xxxxxxxxxxxxxxx>]

>I had heard that ODBC was slow

ODBC isn't slow -- just poorly written odbc <G> 

Seriously though, usually things are "slow" when there isn't an index to
support the query. For example, I've seen a case where a company had
customers "per company" -- that is the primary key to the customer file
wasn't CustomerID it was CompanyID+CustomerID. All the indicies were Company
and Customer, not just customer -- but they were a single company
installation. The VB programmer just tried to get a row "where customerid =
87783" and it was a dog. Change the query to "where companyid = 1 and
customerid = 87783" and it flew. (or create an index on just customerid)

Find out what the query that's running is and then check for a supporting
index. If you can change the VB use a better where, if you can't, create an
index.

-Walden

------------
Walden H Leverich III
President
Tech Software
(516) 627-3800 x11
(208) 692-3308 eFax
WaldenL@TechSoftInc.com
http://www.TechSoftInc.com 

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)
 

-----Original Message-----
From: g man [mailto:g.man2000@lycos.com] 
Sent: Tuesday, January 28, 2003 1: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.