|Subject||Re: [firebird-support] Re: Foreign Key on 2 or more columns|
> oh no it's not a contact database, it's was a sample... it's a real estate property database all around the world ( http://www.arkadia.com/usa/ ) the database is not so big, but when we keep the archived record yes it's become very big !May I suggest you to use two databases? In operative database you can
> now how to easyly move one record from the main table to the archived table by storedprocedure and handle at the same time all foreign key ?
have only small amount records while in archive database you'll have
full set of records (including operative). Actuality of archive database
can be maintained by a replicator.
Operative database can be used for OLTP while OLAP can be done in