Re: ODP: [firebird-support] Re: Issue with large table in FB 1.5 and 2.5

Thu, 06 Jun 2019 22:43:09 -0700 

I resend my email - it do not reaach the yahoo group :-(
 
Hi,
 
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.
 
regards,
Karol Bieniaszewski
 

Reply via email to