|Subject||Re: ODP: [firebird-support] Re: Issue with large table in FB 1.5 and 2.5|
you can try modify your logic by adding IMPORT_ID to that table
and then you can import data without need to delete in the same time.
Then you can delete data in some portions during a day.
and successively run
SELECT COUNT(*) FROM THAT_TABLE
to clear old record versions.
This changed logic require changes in your current selects where you must include most recent IMPORT_ID.