I can't really say, our setup was not very optimized and I never did use
Client Access myself. I relied on my supervisor's evaluation.
However, I remember retrieving a 13,000 personnel record set at peak time on
both the AS/400 and Web server in less than 3 minutes. It sounds like a
long time, but it was quicker than some of the other times we had for
accessing the SQL server on similar sized record sets.
Russel
============================================================
Russel Madere, Jr. Senior Web Developer
ICQ: 5446158 http://www.TurboSquid.com
Some days you eat the bear; some days the bear eats you.
============================================================
> -----Original Message-----
> From: Robert Everland [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 10, 2001 09:37
> To: CF-Talk
> Subject: RE: WDDX for Cobol
>
>
> Is it faster? We are using Client Access 4 and I really haven't had any
> problems with it. It is kind of slow which I am playing with the
> queries to
> make them more effiecient now.
>
> Robert Everland III
> Web Developer
> Dixon Ticonderoga
>
>
> -----Original Message-----
> From: Russel Madere [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 10, 2001 10:24 AM
> To: CF-Talk
> Subject: RE: WDDX for Cobol
>
>
> There is also an ODBC drive for NT To directly pass ODBC commands to a DB2
> database by a company called Hit Software (http://www.hit.com).
> It is easy
> to set up and then appears to Cold Fusion like any other datasource.
>
> We used it over Client Access because of the ease of configuration and
> maintenence. It was "cheaper" to our man power budget than Client Access.
>
> Russel
>
> ============================================================
> Russel Madere, Jr. Senior Web Developer
> ICQ: 5446158 http://www.TurboSquid.com
>
> Some days you eat the bear; some days the bear eats you.
> ============================================================
>
>
> > -----Original Message-----
> > From: Robert Everland [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, January 10, 2001 09:05
> > To: CF-Talk
> > Subject: RE: WDDX for Cobol
> >
> >
> > Well if you have Client access to connect to the AS/400 and
> it's using an
> > offshoot of DB2 somewhere which AS/400 usually uses, you should
> be able to
> > query the database with an odbc connection. We do this now with
> AS/400 and
> > RPG.
> >
> > Robert Everland III
> > Web Developer
> > Dixon Ticonderoga
> >
> >
> > -----Original Message-----
> > From: David E. Crawford [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, January 10, 2001 9:59 AM
> > To: CF-Talk
> > Subject: WDDX for Cobol
> >
> >
> > I know this sounds like a completely lame question, but has
> > anyone attempted
> > to create a WDDX component for COBOL? I have a legacy system
> integration
> > project that would be greatly simplified with the ability to
> have WDDX or
> > other XML component to deal with some data transfer. This is
> on an AS400.
> >
> > DC
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
