dyemanov.blogspot.com
Firebird: Under the Hood: A few words about the shared memory and files
http://dyemanov.blogspot.com/2012/05/few-words-about-shared-memory-and-files.html
Various aspects of the database development and misc thoughts related to the Firebird SQL engine. May 30, 2012. A few words about the shared memory and files. Even if running in the Classic (isolated process) mode, Firebird needs some data to be available to all the running server processes. There are four kinds of information that must be shared:. Also, it should be noted that the shared memory regions were global for the particular server instance. In other words, they handled the shared data for a...
dyemanov.blogspot.com
Firebird: Under the Hood: July 2011
http://dyemanov.blogspot.com/2011_07_01_archive.html
Various aspects of the database development and misc thoughts related to the Firebird SQL engine. July 12, 2011. Data type coercion vs comparison rules. In old versions, different data types couldnt be used as arguments in these cases, throwing the famous error data type unknown, see this simple test case:. Select 1 from rdb$database. Select 1 from rdb$database. If any of the data types in DTS is character string, then:. Select 1 from rdb$database. Select a from rdb$database. July 10, 2011. Reincarnation...
dyemanov.blogspot.com
Firebird: Under the Hood: May 2012
http://dyemanov.blogspot.com/2012_05_01_archive.html
Various aspects of the database development and misc thoughts related to the Firebird SQL engine. May 30, 2012. A few words about the shared memory and files. Even if running in the Classic (isolated process) mode, Firebird needs some data to be available to all the running server processes. There are four kinds of information that must be shared:. Subscribe to: Posts (Atom). Firebird core developer and R&D coordinator. View my complete profile. Firebird 2.5 is out! Adriano dos Santos Ferndandes.
dyemanov.blogspot.com
Firebird: Under the Hood: March 2012
http://dyemanov.blogspot.com/2012_03_01_archive.html
Various aspects of the database development and misc thoughts related to the Firebird SQL engine. March 27, 2012. Firebird vs Windows: file-system caching issue. This article is going to shed some light on the facts related to the issue registered as CORE-3791. In the project bug tracker. Lets start with some links. The origin of the problem is described here:. Http:/ support.microsoft.com/kb/2549369. A lot of additional useful information can be found here (especially in the comments):. March 15, 2012.
dyemanov.blogspot.com
Firebird: Under the Hood: Records batching
http://dyemanov.blogspot.com/2012/03/records-batching.html
Various aspects of the database development and misc thoughts related to the Firebird SQL engine. March 15, 2012. As explained priorly, the fetch response includes multiple resulting records batched together. But how many records should be batched? Now let's review what could be enhanced in this area:. The pipelining threshold could be adjusted dynamically depending on the network specifics. For high-latency networks, it makes a lot of sense to ask for the next batch immediately after receiving the c...
dyemanov.blogspot.com
Firebird: Under the Hood: Firebird vs Windows: file-system caching issue
http://dyemanov.blogspot.com/2012/03/firebird-vs-windows-file-system-caching.html
Various aspects of the database development and misc thoughts related to the Firebird SQL engine. March 27, 2012. Firebird vs Windows: file-system caching issue. This article is going to shed some light on the facts related to the issue registered as CORE-3791. In the project bug tracker. Let's start with some links. The origin of the problem is described here:. Http:/ support.microsoft.com/kb/2549369. A lot of additional useful information can be found here (especially in the comments):. In order to cha...
dyemanov.blogspot.com
Firebird: Under the Hood: Protocol packets and buffers
http://dyemanov.blogspot.com/2012/03/protocol-packets-and-buffers.html
Various aspects of the database development and misc thoughts related to the Firebird SQL engine. February 7, 2012. Protocol packets and buffers. Usually, logical packets are quite small and thus the protocol buffer is always large enough to fit it entirely. The rule of thumb here is that it must be not less than the MSS ( maximum segment size. Value for the given transport layer. For example, Ethernet has MTU ( maximum transmission unit. The protocol buffer size does not matter much there, because the r...
dyemanov.blogspot.com
Firebird: Under the Hood: February 2012
http://dyemanov.blogspot.com/2012_02_01_archive.html
Various aspects of the database development and misc thoughts related to the Firebird SQL engine. February 7, 2012. Protocol packets and buffers. Usually, logical packets are quite small and thus the protocol buffer is always large enough to fit it entirely. The rule of thumb here is that it must be not less than the MSS ( maximum segment size. Value for the given transport layer. For example, Ethernet has MTU ( maximum transmission unit. Subscribe to: Posts (Atom). View my complete profile. Protocol pac...
dyemanov.blogspot.com
Firebird: Under the Hood: January 2012
http://dyemanov.blogspot.com/2012_01_01_archive.html
Various aspects of the database development and misc thoughts related to the Firebird SQL engine. January 14, 2012. Generic thoughts about the network performance. At the software level, there may be different solutions attempted to minimize the number of network round-trips and thus improve the transmission times. Here you can see what has been done in Firebird up to date. Subscribe to: Posts (Atom). Firebird core developer and R&D coordinator. View my complete profile. Firebird 2.5 is out!
SOCIAL ENGAGEMENT