Subject Re: [Firebird-Java] JCA-JDBC Performance
Author mebus@gmx.de
> Hello
>
> Can you give more details about the record format?.
>

Do you think InterClient and JCA-JDBC have different transfer
times because of the record format? Mmmhh!

thank you
Hans Georg

OK here is the create statement:

create table testtab
(an_nr numeric(10,2)
,an_nr_pz numeric(1)
,an_kurznam varchar(30) CHARACTER SET WIN1252
,an_anrede varchar(10)
,an_name1 varchar(30) CHARACTER SET WIN1252
,an_name2 varchar(30) CHARACTER SET WIN1252
,an_name3 varchar(30) CHARACTER SET WIN1252
,an_strasse varchar(30) CHARACTER SET WIN1252
,an_land varchar(3)
,an_plz varchar(10)
,an_ort varchar(50) CHARACTER SET WIN1252
,an_plz_pf varchar(10)
,an_postfach varchar(10)
,an_telefon varchar(50)
,an_telefax varchar(50)
,an_s_datum timestamp
,an_konzern varchar(1)
,an_zertifi varchar(1)
,an_z_iso varchar(1)
,an_z_datum varchar(1)
,an_status varchar(1)
,an_wme_al varchar(10)
,an_wme_alp numeric(1)
,an_kred_nr numeric
,an_erf_dat timestamp
,an_erf_id varchar(30)
,an_fre_dat timestamp
,an_fre_id varchar(1)
,an_s_grund numeric(10,2)
);

--
GMX - Die Kommunikationsplattform im Internet.
http://www.gmx.net