There is no batch update in Firebird 2.5.1/Jaybird 2.2
------------------------------------------------------
Key: CORE-3821
URL: http://tracker.firebirdsql.org/browse/CORE-3821
Project: Firebird Core
Issue Type: New Feature
Components: Engine
Affects Versions: 2.5.1
Environment: All Windows OS platform from Window 2000 to Windows 7.
This is a Java application
Reporter: Sowmitri Swamy
Priority: Critical
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?.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Better than sec? Nothing is better than sec when it comes to
monitoring Big Data applications. Try Boundary one-second
resolution app monitoring today. Free.
http://p.sf.net/sfu/Boundary-dev2dev
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
