Excellent info! The 40gb table limit will be a small problem for us, but not
insurmountable.
Thanks much,
Fred

-----Original Message-----
From: Dalton Calford [mailto:dcalford@...]
Sent: Wednesday, May 12, 2004 10:49 AM
To: Firebird-general@yahoogroups.com
Subject: Re: [Firebird-general] big time firebird


Fred Pratt wrote:

>I have followed this group pretty closely and have not seen a reference to

a

>Firebird database larger than 15GB (and that was my own). Are there larger
>ones out there?
>
>
>

We have large databases. With the need to keep 7 years worth of data
online, with data increasing by 4-5 GB a month, our databases are large.

There are a few points to be made.
1.) no single table can survive the 40GB(approx) mark with current
versions of IB/FB. (Vulcan may eliminate this with 64 bit file
structures) You let the table grow too big, and it will corrupt your
database. (this may be a index issue, have not tried a large table
without a index)
2.) Too many transactions and your transaction counter will wrap,
causing all sorts of grief. So backup and restores are valuable.
3.) Alot of data items can be split between natural breakpoints (dates,
both physical and accounting or some other method) and your client
application or middle ware can look across multiple databases for the data.
4.) Proper hardware design can improve performance, but good schema
design is critical, and the ability to specify table/index placement is
not really an issue, but tempory file placement is.

best regards

Dalton




Community email addresses:
Post message: Firebird-general@yahoogroups.com
Subscribe: Firebird-general-subscribe@yahoogroups.com
Unsubscribe: Firebird-general-unsubscribe@yahoogroups.com
List owner: Firebird-general-owner@yahoogroups.com

Shortcut URL to this page:
http://www.yahoogroups.com/community/Firebird-general
Yahoo! Groups Links