Subject Re: [firebird-support] Historic tables design
Author Iwan Cahyadi Sugeng
On Wed, Jul 31, 2013 at 4:28 PM, Lester Caine <lester@...> wrote:

> **
> Iwan Cahyadi Sugeng wrote:
> > I'm planning to do historical data archive too, and still searching what
> > the best strategies to use. For me, it is best to separate the historical
> > table into it's own table, because the historical table should not have
> any
> > index. If i put the historical table into separate database, that will
> make
> > it harder for me to handle two database update that almost happen on
> every
> > transaction. That what i think of course
> You NEED an index of some sort on every table even if it is just a
> generator
> key, but yes at present Firebird does not support cross database queries,
> so
> separate tables need to be in the same database.
> ( pet hate - if you MUST top post PLEASE switch off quoting altogether!
> It's
> even or annoying when your email client does not respect the sig tag and
> re-quotes the sig as well - I think it's about time I put this as MY sig
> :) )
Sorry about the top post, it's the default in gmail :D
I'm thinking to put and a field on every historic table so the table can
still have an index

Iwan Cahyadi Sugeng
Interaktif Cipta Lestari

[Non-text portions of this message have been removed]