Author: mariuz

http://wiki.ubuntu.com/Mariuz

Shared page cache ready to be commited in firebird 3.0

Leave a comment

Vlad Khorsun wrote about the Shared page cache implementation in 3.0 :
After more than a year of development, testing, switching on another tasks and returning back i’m ready to commit shared page cache implementation into trunk.
I consider it stable enough to be committed into SVN. It runs some stability tests more than 10 hours for longest run and many shorter runs at different configurations.
Here i want to do overview of changes, what was tested, what was not, and what
is work in progress.

You can read more about Shared page cache in the Firebird 3.0 presentation
Update:Feature commited into trunk

Firebird 2.0 (and up) Maximum Number Of Records In Table

Leave a comment
Maximum number of records in table in Firebird is depended on record_size and page_size.
Here is a spreadsheet in Open/Libre Office Calc (for all calculations look at sheet 1, sheet 2, sheet 3 and sheet 4):
I would like to here from developers from Firebird is this calculations are correct.
Here is the original blog post , and here are the related threads on firebird-support

Tips:How to Identify if your run 64 bits of Firebird engine

Leave a comment

Question: I have a requirement to Identify whether a Firebird system is 64 bit or not,in order to know whether to deploy a 64 bit UDF or a 32 bit UDF. Is there any thing to give the correct information?
The best Answer: Identify this information this way:
fbsvcmgr service_mgr -user sysdba -password masterke -info_server_version -info_implementation

see the manual for more  : http://firebirdsql.org/rlsnotesh/rlsnotes210.html#rnfb210-util-svcs

On ubuntu/debian 64 will give :
fbsvcmgr service_mgr -user sysdba -password masterke -info_implementation | grep 64
Server implementation: Firebird/linux AMD64

or you can count if the 64 string is present with -c in grep (notice that there is no need for username and password)

fbsvcmgr service_mgr -info_implementation | grep -c 64

1



 

Jiří Činčura Blogged: Tokenize string in SQL (Firebird syntax)

Leave a comment

Few days ago I wrote “Some thoughts on denormalization” post. Though concatenating data to one string is easy with there introduced function, splitting it back could be harder. I left it as exercise, but I feel, to make it complete, it’s good to show one possible implementation.

Here’s one I came with today (using Firebird syntax, however it’s almost pure SQL), quickly. It’s something I created from start to finish in one row and sure for some cases it could be optimized.

 

Amazon’s EC2 Micro Instance and Firebird

Leave a comment

Jiří Činčura Blogged about his impression on Amazon’s microinstance :

Few months ago I was playing with different VPS providers and I was also considering deploying the application to some “small instance” cloud. I came to Micro Instance of Amazon EC2. Part of the solution I was doing research for is Firebird database and because the pricing looks good, I tried to install Firebird (2.5 SuperClassic) on this instance.

1 … 130 131 132 133 134 … 297