I have an application written in Java which uses IB6 and Firebird
InterClient.

In the application, there are places where I perform an ad-hoc query
and return the results to a GUI. Psuedocode is:

{
db.beginTran();
results = db.exec(selectStatement);
db.commitTran();

return result;
}

I put timings around each statement. Getting the results takes about
100ms, give or take, but the commit takes 10,000ms (almost exactly)
every time. I tried changing the commit to a rollback, and it dropped
to <10ms. I have two questions:

1) Where is that 10 second commit coming from? Some sort of timeout?
2) Is using rollback a safe/viable work-around for this speed issue?

Thanks!
- Dave