Subject Re: [firebird-support] Multi File Database + Dialect 3
Author Helen Borrie
At 09:53 AM 16/09/2003 +0530, you wrote:
>Hello All,
>1.What is a Dialect ?

If you are creating a new database with Firebird, you don't have to worry
about dialect. It will create a Dialect 3 database by default.
Dialect 1 is there to allow the server and clients to work with a database
that was created by InterBase 5.

>2.How to create a multi file DB ,each of size 1Gb and with Dialect 3?

On a Windows server, the following will create a database of three files,
each able to store up to 1 Gb:
CREATE DATABASE 'd:\data\MyData.fdb'
FILE 'd:\MyData1.fdb'
STARTING AT PAGE 128001 /* pages */
FILE 'd:\MyData2.fdb'
STARTING AT PAGE 256001 LENGTH 128000; /* length on last file only */

With Firebird, declaring a multi-file database doesn't reserve the
space. Firebird will fill up the primary file first, then begin using the
first secondary file until it needs more space...and so on.