Hi,
I am a SQL Server and MySQL developer. I am aware of Firebird but never got
opportunity to work with it. I want to use Firebird in one of my upcoming
project replacing MySQL. While reading the documentation of Firebird, I learned
that it supports single as well as multiple database files
Hi Rohit Coder,
welcome to Firebird!
1. Which is the recommended data file structure: `Single file` or `Multiple
files`?
I'll pass on this one. I may give wrong information.
2. What is the table and data file max-size for version 2.5?
Ditto.
3. What are the common scenarios of a
Hi Rohit,
I am a SQL Server and MySQL developer. ]
'welcome!
1. Which is the recommended data file structure: `Single file` or
`Multiple files`?
Single file. The multiple file structure was invented when databases were
bigger than disks. Even the multiple-file configuration mixes
On Wed, Sep 28, 2011 at 15:58, Rohit Coder
passionate_program...@hotmail.com wrote:
2. What is the table and data file max-size for version 2.5?
http://www.firebirdfaq.org/faq61/
3. What are the common scenarios of a Firebird data file getting corrupt? In
case of a single-file structure, I
Hello,
3. What are the common scenarios of a Firebird data file getting
corrupt? In case of a single-file structure, I guess no other files
need to be backed up?
There are some articles on our site
Firebird and InterBase corruptions reasons
http://www.ib-aid.com/articles/item70
On Wed, 28 Sep 2011 11:52:01 -0400, Ann Harrison aharri...@ibphoenix.com
wrote:
2. What is the table and data file max-size for version 2.5?
I think it's 32K * the page size. Huge.
Hi Ann, I assume you mean something like 2^32 * pagesize, because 32K * a
pagesize of 16K isn't that much
On Wed, Sep 28, 2011 at 18:48, Alexey Kovyazin a...@ib-aid.com wrote:
1) Full hard disk: IIRC in this case Firebird will overwrite the file
from the beginning. Not good, but checking for free space on every
write would slow down writes too much. Just make sure you have enough
space.
This is
