Firebird delete+insert vs update+insert

Question

I just want to know which is faster in firebird. If it's delete then insert all the data or the UPDATE OR INSERT query in the firebird database, my data for this is almost a hundred thousand records.

Answer 1

I would go for update or insert. Delete is not that fast on firebird. Also, bulk deletes will leave that space unused in the file. If you do this often, the file will stay larger than it needs to be. Until you backup and restore.