RE: ODBC Performance issue

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

>We changed over to sockets and have no
>noticeable impact on the system.

No argument. Sockets will almost always perform better than ODBC/OLEDB.
However, you're trading ease of programming for performance -- sometimes
valid, sometimes not. I like the fact that I can hire ASP programmers that
can't spell AS/400 and they can connect and access my iSeries data via
odbc/oledb. 

BTW, sockets aren't directly accessable from ASP. What did you write your
interface layer in? VB?

-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: Cyndi Bradberry [mailto:CyndiB@IHFA.ORG] 
Sent: Thursday, January 30, 2003 9:17 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: ODBC Performance issue


Girish, 

We had severe performance degradation using ODBC interfacing to a Window's
web server running ASP pages. We changed over to sockets and have no
noticeable impact on the system. We now have three external websites and one
internal website that all use sockets. We also have one VB app that has been
deployed that interfaces via sockets and one more that is in testing. The
first one is a stand alone, the VB app in testing will launch from a green
screen and carry with it parameters.

All the socket programs run in batch in the QUSRWRK subsystem. 

I recommend the "Who Knew You Could Do that with RPG" book. I used it as the
basis of all our socket programming.

http://publib-b.boulder.ibm.com/Redbooks.nsf/RedbookAbstracts/sg245402.html?
Open


Good Luck,
Cyndi B.
Idaho
_______________________________________________
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.