Issue Details (XML | Word | Printable)

Key: CORE-2530
Type: Improvement Improvement
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Carlos H. Cantu
Votes: 234
Watchers: 57
Operations

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

Denser data stream and better prefetch logic in the network protocol

Created: 26/Jun/09 10:19 AM   Updated: 18/Jan/16 06:02 PM
Component/s: Engine
Affects Version/s: None
Fix Version/s: 3.0 Beta 1

Issue Links:
Relate
 

QA Status: No test


 Description  « Hide
Firebird 2.1 has already a improved network protocol, but it is still slow for internet connections (ADSL, etc). With globalization, it is a must that the protocol work better with internet connections. Private talks with Dmitry Yemanov and Vlad shows that there is still room for improvement so, here is the request.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Pavel Cisar added a comment - 26/Jun/09 04:14 PM
Please, stop spamming the tracker. If you want to raise the importance of any particular entry, use the voting system, not comments.

Fausto Alves added a comment - 26/Jun/09 06:04 PM
This is an important implementation, since MySql, Post Gree sql, include this feature and believe that the Firebird should also comtempla it.
Yeah, I like many other users would be assisted in their needs.

Ricardo Cardoso added a comment - 26/Jun/09 07:19 PM
I'm working in a project with FB2.x in a network but I have plans to put on the Internet but using FB. Actually I'm using MySQL 5.0 for this because I'm worried with the protocol performance over the internet. Having this changing I can abandon MySQL and use only FB.

Regards,
Ricardo.

Dmitry Yemanov made changes - 26/Jun/09 07:48 PM
Field Original Value New Value
Comment [ It's great !!! ]
Dmitry Yemanov made changes - 26/Jun/09 07:48 PM
Comment [ This is very important and should be improved as soon as possible ]
Dmitry Yemanov made changes - 26/Jun/09 07:48 PM
Comment [
This is very important ]
Dmitry Yemanov made changes - 26/Jun/09 07:49 PM
Comment [ I think lacks this for terms a competitive product ]
Dmitry Yemanov made changes - 26/Jun/09 07:49 PM
Comment [ Firebird needs to fly! ]
Dmitry Yemanov made changes - 26/Jun/09 07:49 PM
Comment [ Lets prepare to great speed in the internet ]
Dmitry Yemanov made changes - 26/Jun/09 07:49 PM
Comment [ Very, Very Good and important ]
Dmitry Yemanov made changes - 26/Jun/09 07:49 PM
Comment [ This is very very very very very very ...........important ]
Dmitry Yemanov made changes - 26/Jun/09 07:49 PM
Comment [ I already use remote connections with zebedee and encryption on the fly for known clients so if firebird has such a built in feature it will be great ]
Dmitry Yemanov made changes - 26/Jun/09 07:49 PM
Comment [ Very important. ]
Dmitry Yemanov made changes - 26/Jun/09 07:50 PM
Comment [ For me, it's very important too ]
Dmitry Yemanov made changes - 26/Jun/09 07:50 PM
Comment [ One the most important feature for FB next version. ]
Dmitry Yemanov made changes - 26/Jun/09 07:50 PM
Comment [ It's very important... ]
Dmitry Yemanov made changes - 26/Jun/09 07:50 PM
Comment [ Yes, please! This will make many users happy :-) ]
Dmitry Yemanov made changes - 26/Jun/09 07:50 PM
Comment [ Yes, we need this feature in the next version! ]
Dmitry Yemanov added a comment - 26/Jun/09 08:26 PM
I have removed all the comments of the "it's great!" style as they may hide the "on-topic" technical comments and they don't belong to the bug tracker in general, as already mentioned by Pavel. Please use the voting facility, it's enough to express your wishes.

Luciano Ferreira added a comment - 30/Jul/09 10:09 AM
It's very important...

Joao Americo fabrício added a comment - 08/Oct/10 11:28 AM - edited
I think it is very important as it will, probably, "stop" people "moving" their project from FB to Mysql when they need to add any internet issue.

I did not checked if FB already got it done, but add some kind of "compression" to packets/protocol as mysql/mssql/oracle/postgres/sybase do should be the first step.

PS. Please, use the "," (coma) at the right place to make your post easy to understand. As Im brazilian I anderstood, but ppl that does not talk in Portuguese will understand really NOTHING.

Lars Dybdahl added a comment - 01/Feb/12 02:37 PM
A very slow process is to fetch many blobs. Fetching 100 times 100kbyte blobs takes a very long time, because each blob is fetched in it's own request. Instead, it would be very beneficial to be able to ask the server to deliver blob content immediately, as part of the same request.

Dmitry Yemanov made changes - 08/Feb/12 05:24 AM
Assignee Dmitry Yemanov [ dimitr ]
Dmitry Yemanov made changes - 08/Feb/12 09:49 AM
Status Open [ 1 ] In Progress [ 3 ]
Dmitry Yemanov made changes - 29/Mar/14 06:15 AM
Fix Version/s 3.0 Beta 1 [ 10332 ]
Dmitry Yemanov made changes - 27/Apr/14 09:15 AM
Link This issue relate to CORE-2897 [ CORE-2897 ]
Dmitry Yemanov made changes - 11/Oct/14 06:42 PM
Status In Progress [ 3 ] Resolved [ 5 ]
Resolution Fixed [ 1 ]
Dmitry Yemanov added a comment - 11/Oct/14 07:08 PM
The "improved protocol" is a too flexible term that may mean lots of things, so I've adjusted the ticket title to reflect what has been improved now. Other improvement requests (e.g. blobs sent along with records) may deserve separate tickets.

In v3, the following improvements are implemented:

1) NULL flags (4 bytes per field) are replaced with a bitmap. NULL fields are no longer transmitted, except the corresponding bits in the bitmap (see also CORE-2897). This is available for DSQL API only, so unfortunately GBAK does not benefit from this improvement (as it uses a lower level BLR API).

2) Prefetch (batch receive) algorithm is now aware of variable-length messages (VARCHARs and NULLs may reduce the transmitted message size), so more rows can be transmitted within a single batch.

Dmitry Yemanov made changes - 11/Oct/14 07:08 PM
Summary Improve even more the FB network protocol Denser data stream and better prefetch logic in the network protocol
Pavel Cisar made changes - 23/Sep/15 12:16 PM
Status Resolved [ 5 ] Closed [ 6 ]
Pavel Zotov made changes - 18/Jan/16 06:02 PM
QA Status No test