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 :) )

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk