What page size should I use?

It’s a common question with interesting background from developers . As I can suppose from IBSurgeon statistics, 99% of Firebird and InterBase developers use default page size: since the old ages it is 1024 bytes, and only for Firebird 2.0 it is changed to 4096 by default. There are 4 main things related with page size: indices depth, database cache size, records per page quantity and disk cluster size.

The shortest answer to this question is to use 4k, 8k or 16k page size. That’s it.

If you want to go a bit deeper, keep reading

OpenSQL Camp

Open-source databases have become quite prominent over the last decade, in large installations as well as small ones. MySQL and PostgreSQL are the best-known open-source databases, but SQLite, Firebird, and CouchDB are also popular in some corners, and offer compelling features of their own. In some cases, users aren’t even aware that they have installed a database: For example, the Firefox Web browser comes with an installation of SQLite, which it uses to manage preferences and passwords.

Read full article here.

Delphi 2009 is out

But still no “official” support for Firebird, as Nick Hodges states in this podcast. BUT, rumors says that there will be news about this in the future.

Anyway, Firebird users has tons of third party access components (IBO, FIBPlus, InterXpress, UIB, Zeos, etc. etc.) to be used with Delphi so, no official support doesn’t mean any big problem for us.

Check the press release information here. This is the first Delphi version released after CodeGear was sold to Embarcadero.

1 54 55 56 57 58 100