Subject Re: Test results: JayBird vs Interclient on blob select on Linux and Windows
Author Roman Rokytskyy <rrokytskyy@acm.org>
> I want to hope very much on the happy end with JayBird driver in
> this situation though.

My results: Laptop Acer TravelMate 202TE, Celeron 650 MHz, 320 MB
RAM, IBM 40 GB HDD, Windows 2000, Sun JDK 1.3.1_02, Firebird 1.0
(build 794), JayBird from CVS, InterClient 2.01.

FillBlobs.java
--------------
org.firebirdsql.jdbc.FBDriver
jdbc:firebirdsql:localhost/3050:C:\test.gdb
array.length=51200
time2 = 6039

ReadBlobs.java
--------------
args[0] = win
args[1] = fb
org.firebirdsql.jdbc.FBDriver
jdbc:firebirdsql:localhost/3050:C:\test.gdb
time1 = 1282 time2 = 100 time3 = 3856
time1 = 1162 time2 = 150 time3 = 3666
time1 = 1191 time2 = 90 time3 = 3626

args[0] = win
args[1] = ic
interbase.interclient.Driver
jdbc:interbase://localhost/C:\test.gdb
time1 = 1092 time2 = 10 time3 = 2764
time1 = 1032 time2 = 10 time3 = 2713
time1 = 1051 time2 = 0 time3 = 2694

As you see, IC/JB performance when server and application run on the
same host is ~70%, and these results are pretty stable for other
applications (you can find posts from Blas with more details).

I will try this on Linux later.

Best regards,
Roman Rokytskyy