Aage,
Thanks for the lone reply. The ability to place heavily used tables on
separate disks has proven to be a very helpful feature for us - at least
with Informix. All major database vendors support this feature, so someone
is finding it helpful out there. :-) We backup/restore in order to
eliminate all of the garbage and to re-balance the indexes. We probably do
this too often, but it's the simplest way to do these things with a smaller
database.
Thanks again.
Fred

-----Original Message-----
From: Aage Johansen [mailto:aagjohan@...]
Sent: Thursday, April 29, 2004 3:08 PM
To: firebird-general@yahoogroups.com
Subject: Re: [Firebird-general] big time firebird

On Thu, 29 Apr 2004 14:08:55 +0000 (UTC), flpratt wrote:

> I'm looking for firebird users who are supporting large databases. We
> are an informix and firebird shop and have a big project in development.
> While we use firebird extensively for small apps ( < 5gb ) we are
> hesitant to use it for databases in the hundreds of gb's. Two reasons we
> question firebird's ability to scale are lack of table placement control
> (you can't put a large table on a separate disk volume) and the apparent
> need to backup/restore frequently to keep things "tidy".
> We are very happy with firebird for the smaller apps and want to use it
> for larger ones. Anyone out there have a really large firebird database?
> Any replies are greatly appreciated,


We backup often, but hardly ever restore (except for testing that the
backup file is valid). What kind of 'untidyness' are you thinking of? A
need for SWEEPs, perhaps?

My db's are quite small - just a few GB's at most - so I cannot help you on
the really big ones. One problem might be 'how long does a backup
take?'. It seems much quicker with Fb/1.5 than with older versions, but
hundreds of GB's may still be a problem. Maybe the backup mechanisms for
Fb/2.0 will make this less of a problem.


BTW, have you measured the effect of 'table placement'?


--
Aage J.



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