Subject | Slow jdbc with ColdfusionMX |
---|---|
Author | Bradley Tate |
Post date | 2004-04-04T05:11:43Z |
Hi.
We're running a current level Coldfusion MX server on Linux with the
latest released Firebird JDBC drivers and are finding query performance
is 2 to 5 times slower than Coldfusion 5 with ODBC. CFMX itself appears
significantly faster than CF5, it's just the queries which are causing
trouble for us. MX, for those who don't know, is mostly written in Java.
Can anyone offer an opinion as to why this might be happening and what,
if anything, we can do about it? Next thing we're planning to try is a
jdbc to odbc gateway with the old drivers, a course I'd rather avoid if
possible.
Cheers,
Bradley.
We're running a current level Coldfusion MX server on Linux with the
latest released Firebird JDBC drivers and are finding query performance
is 2 to 5 times slower than Coldfusion 5 with ODBC. CFMX itself appears
significantly faster than CF5, it's just the queries which are causing
trouble for us. MX, for those who don't know, is mostly written in Java.
Can anyone offer an opinion as to why this might be happening and what,
if anything, we can do about it? Next thing we're planning to try is a
jdbc to odbc gateway with the old drivers, a course I'd rather avoid if
possible.
Cheers,
Bradley.