Subject Re: [Firebird-Java] JCA-JDBC Performance
Author Blas Rodriguez Somoza
Hello

Can you give more details about the record format?.

Regards
Blas Rodriguez Somoza

----- Original Message -----
From: <mebus@...>
To: <Firebird-Java@yahoogroups.com>
Sent: Tuesday, May 28, 2002 4:11 PM
Subject: [Firebird-Java] JCA-JDBC Performance


> Hi,
>
> we have made here some performance tests JCA-JDBC
> vs. InterClient. The results are very interesting.
>
> The differences we have on localhost are very
> small. JCA-JDBC is about 10% slower then InterClient.
> But having a remote connection writing with JCA-JDBC
> is horrible slow, while reading is about the same
> with InterClient again.
>
> Writing 5000 Records with JCA-JDBC takes 1005186 Millis
> while writing with InterClient takes just 10385 Millis!
>
> That is not acceptable!
>
> Any Idea what is going on? I know that mixing TCP/IP,
> IPX/SPX and Netbios is not the fastest way. But that
> does not declare the differences.
>
> I looked how long it takes to get an connection to the
> database. There were no notable differences from local
> to remote. A litle System.out in write loop showed that
> writing the records is too slow.
>
> That can be a very brutal knock out!
>
> What can I test or change?
>
> Thanks a lot
> Hans Georg
>
> --
> GMX - Die Kommunikationsplattform im Internet.
> http://www.gmx.net
>
>
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>