RE: - the simple query on the 400: SUBJECT CHANGE to SQL Server faster

["Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>]

> From: Jim.Nelson@RCIS-NET.COM
>
> I'll add one more piece.  We currently use the AS/400 as the
> database server
> for our web applications, but if we cannot get the system
> performing better
> we'll have to migrate the apps off the 400.  Am hoping this is
> not the case
> (last thing I need is another replication project) but the performance
> difference is that significant.

Okay, now I'm confused.  What does VB ODBC performance have to do with web
applications?  Are you distributing thick-client VB programs and then
connecting them via ODBC to an AS/400?  Or are you running VB applications
on a Microsoft web server and using the AS/400 as a back end processor?  In
either case, you might want to look into a different architecture.  Servlets
and JSP perform quite nicely on the AS/400.

Joe