On Wed, Jul 31, 2013 at 4:28 PM, Lester Caine <[email protected]> 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]
