Subject | Performance |
---|---|
Author | Blas Rodriguez Somoza |
Post date | 2002-10-25T00:30:31Z |
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
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