--- In firebird-support@yahoogroups.com, "emb_blaster" <EMB_Blaster@...> wrote:

>
> > >
> > > the better option is to put all the archived record in a dedicated
> > > archived table !
> > >
> > > no ?
> > >
> > > stephane
> >
> > yeh - for 70million I'd use a separate table.
>
> 70mi contacts iayeh! :-O
> maybe, you'll control a pseudo-FK in soft, and let only indexes and constraints in DB?

not contact, was an exemple... just real estate properties. I don't like the idea that the soft must control the FK because one day one developper will do a bulsheet and the database could be corrupted. i prefere a way to control the pseudo-fk by trigger inside the database engine. but in fact worse is that the table archived could also be in a separate database in this way... :(

>
> > that's a few small country's worth of people there. SPAM database by any
> > chance? :-)
> > Alan
> >
> please say my name or mail isn't there! :-)
>
> regards,
>

don't worry :)