Issue Details (XML | Word | Printable)

Key: JDBC-497
Type: Improvement Improvement
Status: Closed Closed
Resolution: Fixed
Priority: Blocker Blocker
Assignee: Mark Rotteveel
Reporter: A Drouard
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Jaybird JCA/JDBC Driver

Slow read of blob and high memory usage

Created: 01/Jun/17 09:50 AM   Updated: 05/Jun/17 01:14 PM
Component/s: JDBC driver
Affects Version/s: Jaybird 3.0.0
Fix Version/s: Jaybird 3.0.1, Jaybird 3.1

File Attachments: 1. Java Source File TestReadBlob.java (3 kB)

Environment: Windows 8, Java 8, Firebird 2.5


 Description  « Hide
I recently upgraded from Jaybird 2.2.9 to Jaybird 3.0.0.
My application is reading a lot of BLOB, and since the upgrade, I noticed a degradation of performance and memory usage.
The problem is particulary visible when reading 2 BLOB columns.

-----------------------------------
Reading 1 blob column :
Jaybird 2.2.9 : 300 000 rows fetched in 45 564 ms, connection closed in 0 ms, heap memory usage : 20 MB
Jaybird 3.0.0 : 300 000 rows fetched in 77 130 ms, connection closed in 28 000 ms, heap memory usage : 687 MB
-----------------------------------
Reading 2 blob columns :
Jaybird 2.2.9 : 300 000 rows fetched in 102 960 ms, connection closed in 1 ms, heap memory usage : 25 MB
Jaybird 3.0.0 : 300 000 rows fetched in 325 930 ms, connection closed in 16 3967 ms, heap memory usage : 653 MB

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no subversion log entries for this issue yet.