==========================================================================
* Forwarded by Roman Rokytskyy
* From: "Claus Heeg"
* Date: Tue, 06 Apr 2004 14:51:12 +0200
* To: "Roman Rokytskyy"
* Subj: ColdFusionMX + Jaybird vs. ColdFusion5 + ODBC (Firebird
IBphoenix)
==========================================================================

| *Dear Roman,
I can verify the difference with Coldfusion Servers Version 5 and 6.1
I have 2 application server one CF5 under Windows 900Mhz/1GB Ram and one
CFMX Suse opteron 248 1GB RAM JAYBIRD1.5
the database is under HPUX FireBird1.0.3- the situation is the similar
(never the same)

As it appears to me we cd say that in CFMX with Jaybird
1) the first time parsing the query JDBC (Jaybird1.5) is up 5 times
slower as ODBC

2) after parsing the CFM Module it the query is same or similar speed
or goes to down 9 ms !

3) the delay in the first query is to explain by a onthefly compiler
with in the CFMX-JRUN engine.

Also I found that the "OBDC/JDBC bridge" in CFMX 6.1 is far slower then
the JDBC !
best regds
Claus
you can post this to the Group - I just want to give you a chance to
comment first....

COLDFUSION MX + Jaybird; 1.) 511 ms 2) 19 ms 3) 32 ms 4) 15ms
----------------------------------------------------------------------------
q_dm_status* (Datasource=system2_tfx, Time=511ms, Records=0) in
/opt/coldfusionmx/wwwroot/cf/zyl001.cfm @ 14:24:52.052|

select distinct a.prod_nr, a.druck_masch, a.plan_dat, a.mde_status ,
a.reihenfolge , a.dess_nr , a.druckort,
a.prodzeit_bis , a.freigabe, a.zyl_anforderung, a.farbe_fertig ,
a.prio_kz, b.anz_zyl
from pps_ela a, law_dess b
where a.druckort ='KOH' and a.druck_masch = 1
and a.freigabe = 5
and a.mde_status in ('45')

and a.zyl_anforderung = 'Z'

and a.firmen_nr = '0111'
and b.firmen_nr = '0111'
and a.dess_nr = b.dess_nr
order by a.reihenfolge

| *q_dm_status* (Datasource=system2_tfx, Time=19ms, Records=0) in
/opt/coldfusionmx/wwwroot/cf/zyl001.cfm @ 14:24:52.052|

select distinct a.prod_nr, a.druck_masch, a.plan_dat, a.mde_status ,
a.reihenfolge , a.dess_nr , a.druckort,
a.prodzeit_bis , a.freigabe, a.zyl_anforderung, a.farbe_fertig ,
a.prio_kz, b.anz_zyl
from pps_ela a, law_dess b
where a.druckort ='KOH' and a.druck_masch = 2
and a.freigabe = 5
and a.mde_status in ('45')

and a.zyl_anforderung = 'Z'

and a.firmen_nr = '0111'
and b.firmen_nr = '0111'
and a.dess_nr = b.dess_nr
order by a.reihenfolge

| *
*||*q_dm_status* (Datasource=system2_tfx, Time=33ms, Records=0) in
/opt/coldfusionmx/wwwroot/cf/zyl001.cfm @ 14:30:31.031|

select distinct a.prod_nr, a.druck_masch, a.plan_dat, a.mde_status ,
a.reihenfolge , a.dess_nr , a.druckort,
a.prodzeit_bis , a.freigabe, a.zyl_anforderung, a.farbe_fertig ,
a.prio_kz, b.anz_zyl
from pps_ela a, law_dess b
where a.druckort ='KOH' and a.druck_masch = 1
and a.freigabe = 5
and a.mde_status in ('45')

and a.zyl_anforderung = 'Z'

and a.firmen_nr = '0111'
and b.firmen_nr = '0111'
and a.dess_nr = b.dess_nr
order by a.reihenfolge

| *q_dm_status* (Datasource=system2_tfx, Time=14ms, Records=0) in
/opt/coldfusionmx/wwwroot/cf/zyl001.cfm @ 14:30:31.031|

select distinct a.prod_nr, a.druck_masch, a.plan_dat, a.mde_status ,
a.reihenfolge , a.dess_nr , a.druckort,
a.prodzeit_bis , a.freigabe, a.zyl_anforderung, a.farbe_fertig ,
a.prio_kz, b.anz_zyl
from pps_ela a, law_dess b
where a.druckort ='KOH' and a.druck_masch = 2
and a.freigabe = 5
and a.mde_status in ('45')

and a.zyl_anforderung = 'Z'

and a.firmen_nr = '0111'
and b.firmen_nr = '0111'
and a.dess_nr = b.dess_nr
order by a.reihenfolge

| *
----------------------------------------------------------------------------

COLDFUSION 5 ODBC time for queries: 1.) 30ms 2.) 30ms 4) 30 ms
*|

*q_dm_status* (Records=0, Time=30ms)
SQL =
select distinct a.prod_nr, a.druck_masch, a.plan_dat, a.mde_status ,
a.reihenfolge , a.dess_nr , a.druckort,
a.prodzeit_bis , a.freigabe, a.zyl_anforderung, a.farbe_fertig ,
a.prio_kz, b.anz_zyl
from pps_ela a, law_dess b
where a.druckort ='KOH' and a.druck_masch = 1
and a.freigabe = 5
and a.mde_status in ('45')

and a.zyl_anforderung = 'Z'

and a.firmen_nr = '0111'
and b.firmen_nr = '0111'
and a.dess_nr = b.dess_nr
order by a.reihenfolge

*q_dm_status* (Records=0, Time=30ms)
SQL =
select distinct a.prod_nr, a.druck_masch, a.plan_dat, a.mde_status ,
a.reihenfolge , a.dess_nr , a.druckort,
a.prodzeit_bis , a.freigabe, a.zyl_anforderung, a.farbe_fertig ,
a.prio_kz, b.anz_zyl
from pps_ela a, law_dess b
where a.druckort ='KOH' and a.druck_masch = 2
and a.freigabe = 5
and a.mde_status in ('45')

and a.zyl_anforderung = 'Z'

and a.firmen_nr = '0111'
and b.firmen_nr = '0111'
and a.dess_nr = b.dess_nr
order by a.reihenfolge


==========================================================================
With best regards, Roman Rokytskyy.