Issue Details (XML | Word | Printable)

Key: CORE-3821
Type: New Feature New Feature
Status: Closed Closed
Resolution: Duplicate
Priority: Critical Critical
Assignee: Unassigned
Reporter: Sowmitri Swamy
Votes: 0
Watchers: 2

If you were logged in you would be able to see more operations.
Firebird Core

There is no batch update in Firebird 2.5.1/Jaybird 2.2

Created: 18/Apr/12 07:28 PM   Updated: 17/Oct/14 08:04 AM
Component/s: Engine
Affects Version/s: 2.5.1
Fix Version/s: None

Environment: All Windows OS platform from Window 2000 to Windows 7. This is a Java application
Issue Links:

 Description  « Hide
There is no batch update in Firebird 2.5.1/Jaybird 2.2.

Our application is a complex technical product that analyzes firewall behavior and security. It creates humongous tables with 10000 plus rows for each firewall.
When we have remote clients writing to the db, we find performance to be very, very slow (30 minutes for a firewall) largely because of the row by row db update, which involves a round trip across the network..
Due to network latency, each round trip is very slow making our product unusable when remote clients are used. With local clients the same operation takes a minute.

We think a batch update is the answer. We know MySQL has it but we prefer to remain with Firebird. Do we have any hope?.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Mark Rotteveel added a comment - 18/Apr/12 08:03 PM
Duplicates CORE-820

Dmitry Yemanov added a comment - 19/Apr/12 02:18 AM
In the meantime, EXECUTE BLOCK could be a workaround.