Subject Performance
Author Blas Rodriguez Somoza
Hello

I've been working on performance the last week and I have commited some performance patches in the last two days.

The patches are focused on JDBC/GDS and does not include changes to connection and transaction management.

Testing the driver now in CVS against RC1a, performance enhancements can be between 0% and 30%.

Now the time FB employ in inserts and selects measured as % of IC time, using explicit transaction control, are
- Inserts between 130 and 140% of IC time.
- Selects from tables with numeric data 10-15% (it is not a mistake, it seems IC has some problems here)
- Selects from tables with varchar data 140-150%
- Selects from tables with char data 186-194%.

Those numbers are for large selects/inserts, for short ones the results can be very different.

Please update your drivers from CVS to test the patches.

Regards
Blas Rodriguez Somoza