Well what I have been using so far is Client Access 4 to communicate
with the AS/400 but what I have been messing around lately is trying to mess
with existing queries to speed them up because going to cold fusion the
average query time is around 2000ms which is pretty long. Though with
rewriting the queries I have gotten the cache time down to around 300ms it
is still kind of long. I was able to add the oledb to CF but it didn't have
the translating turned on so that didn't work out so good. With the
rewriting of queries I have been trying to write the joins at the end
instead of the beginning because they are such huge databases, that has
helped a little but not enough with that I am happy with the speed. So if
anyone out there has gotten the oledb to work or anything I would appreciate
hearing it, though I may mess with some ADO to see if I can get that to
work, but at the same time I didn't see an option to translate.
Robert Everland III
Web Developer
Dixon Ticonderoga
-----Original Message-----
From: Simon Horwith [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 19, 2000 9:43 AM
To: CF-Talk
Subject: RE: Avg AS/400 Query time
I haven't worked much at all with AS400 and ColdFusion together, but I do
have a strong AS400 background, and would certainly appreciate hearing a
little about what you're doing and/or what fixes/tips/tricks you encounter
in dealing with AS400 databases from CF. You can e-mail me offline if you
prefer.
~Simon
> Simon Horwith
> Certified ColdFusion Instructor
> Certified ColdFusion Developer
> Fig Leaf Software
> 1400 16th St NW, # 220
> Washington DC 20036
> 202.797.6570 (direct line)
> www.figleaf.com
>
-----Original Message-----
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 19, 2000 9:01 AM
To: CF-Talk
Subject: Avg AS/400 Query time
I am doing a lot of AS/400 integration with CF and was wondering
what some other people on the list usually get for avg query time. My query
time is rather high and was wondering if anyone has found some tricks, got
the ole db to work right, or any other enhancements that could help speed
things up.
Robert Everland III
Web Developer
Dixon Ticonderoga
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
