Todd-
I had much the same epiphany, except it was with Java stored procedures in
Oracle. I wrote a pretty slick procedure that connected to various boxes
using sockets and retrieved XML files for processing. The neat thing about
Java is its extensive libraries. I don't think I've ever needed to do
anything that couldn't be done readily using one of the provided classes.
Alex
>
> Java functionality in the database seems pretty cool to me, though I'm
only,
> barely, scratching the surface of it. Our DBA thinks it's a pretty slick
> first step, though, and it promises to take even more of a load off of the
> CF server(s). He's already close to finnishing a completely seperate DB
> procedure that will verify and/or replace the contents of city and state
> fields in the database, based on a batched call to the USPS in the wee
hours
> of the morning This will keep the CF server from having to do it in real
> time through some CF_ or CFX tag, when a form is submitted. That should,
> definately, speed up performance under an even moderate load.
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-community@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists