Subject Re: Record-level synchronization
Author Alexander V.Nevsky
--- In ib-support@yahoogroups.com, "David Montgomery"
<montgomery_list@y...> wrote:
> Hi everyone,
>
> I've got a project in front of me that can be described like this:
>
> 1) Remote database containing a few gazillion records in thousands
of
> tables

David, though I _very_ like FB, I'm afraid any IB clon is not ready
yet to carry such a databases. Firstly, what volume in Gbytes are you
expecting in main database? If it will be hundred(s) of Gbs... Note
you should time to time make backup/restore, it can require
unacceptable for your customer time interval when database is offline.
As far as I know Dalton Calford have huge databases, perhaps you
should try to consult with him. Secondly, there are still some
problems with mass upadates/deletes and garbage collection after it.
I'll be happy if more experienced in mantaining huge database
colleagues will reassure us on this subjects, my experience is limited
approximately 10Gb databases. What about structure complexity - I
don't see problems with FB there.

Best regards, Alexander.