Subject Re: Slow jdbc with ColdfusionMX
Author 21cs
They are on different servers. This was the case with CF45/ODBC
(Win2K) and CFMX/Jaybird(Win2003). The database server is a separate
machine (Win2K), and it hasn't changed. The new CFMX server is not
in the same building as the DB server, whereas the CF45 server was in
the same room. Physical distance may be part of the problem, but
it's hard to say since all are part of the city's network and I don't
know the details of the routing (I'm in software). Hope this
information helps.

--- In, "Roman Rokytskyy"
<rrokytskyy@a...> wrote:
> --- In, "21cs" <chasrandal@y...>
> > I'm faced with the same problem - queries taking much longer to
> > complete. We've built a new server with Win2003, CFMX 6.1,
> > 1.0.1, (with Firebird DB running on its own server), and we're
> > hoping to go live this week. Current platform is Win2K, CF45,
> > IBphoenix ODBC driver, datasources linked to same Firebird DB
> > server (works great!). Most queries are fairly short running, so
> > this isn't a show-stopper, but I would like to know why. It
> > that there might be an overhead or connection issue, because the
> > increase is greater with short queries (i.e. 20ms queries run 4x
> > longer, 1 sec queries run 50% longer).
> Not necessarily with connection, but with socket too. Do you run
> Firebird on the same host as ColdFusionMX? In this case you should
> try type 2 driver from CVS as well as embedded version. Also it
> be great to check performance between ODBC and JayBird when
> runs on separate server.
> Can you report your findings here? If my guess is correct, I have a
> good explanation :) If not, then we have to look for a bug.
> Thanks!
> Roman