Hi All

I did some tests with the new driver and I am having a massive speed issue.
I have a database with a table containing a single record with a 5MB blob
(bmp). If I select this record using firebirdsql it takes about 9 Min and
30 sec until it is ready. If I use interclient... it takes 35 sec !!!

I already discovered one problem while I did my first tests. It wrote a
huge log file (900MB). Now I removed the log4j jar file and it is no longer
writing the log but it is still not usable for such big blobs.

My configuration is as following:

Server:
SuSE Linux
Firebirt 09 something
Interserver 2 or 2.01 (not sure)

Client:
W2000
JBuilder 4 IDE

Network:
routed 10MBit/s connection => effective about 4MBit/s

The only thing I changed for the test runs was the line where I specify the
driver.

Here is a part my test code:

query.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(db,
"select * from test", null, true, Load.ALL));

db.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor(
"jdbc:firebirdsql:trans/3050:/dbs/blobtest.gdb", "sysdba",
"hag11ach", false, "org.firebirdsql.jdbc.FBDriver"));
// "jdbc:interbase://trans//dbs/blobtest.gdb", "sysdba", "hag11ach",
false, "interbase.interclient.Driver"));<<======= interclient

db.setDatabaseName("");

db.setTransactionIsolation(java.sql.Connection.TRANSACTION_REPEATABLE_READ);
db.setAutoCommit(false);
jdbNavToolBar1.setDataSet(query);
jdbTable1.setDataSet(query);
contentPane.add(tableScrollPane1, BorderLayout.CENTER);
tableScrollPane1.getViewport().add(jdbTable1, null);
contentPane.add(jdbNavToolBar1, BorderLayout.NORTH);

I remember someone saying something about pocket sizes which can be
changed? But I was not able to find this in the archive. Or is it the gds
protocol which is slowing down things?

Thanks for any help,

Herbert