Subject RE: [ib-support] 32 vs 64 bit?
Author Leyne, Sean
Rick,

> I apologise if this has been covered before but does anybody have any
> experience migrating a 32 bit db to 64 bit?

In fact there isn't really much of a 'migration' necessary.


> I am presuming that the .gdb files are incompatible and I
> will have to do a migration.

No, the 'migration' involves using the correct engine binary on a server
with a hard disk which has a file system which supports 64 bit file
addressing/IO


> Is it more efficient to run a 32 bit db (X86 architecture
> under Linux) with multiple .gdb files, or a single 64 bit db?

I prefer a single file. One of the problems with secondary file, is
that the file paths are stored as an absolute reference in the 'primary'
db, so moving the DB is a hassle.


> I've got an existing db that I need to add a table to that
> has large blobs (graphics files).

I would recommend storing the files as separate OS files in a specific
path, and only store the filename in the DB.


Sean