Subject big change after restore
Author Nick Upson
I'm trying to understand why there is such a large difference in runtime
between these 2 situations.
firebird 2.1.5

run a script to create 130000 records in a table, then use it for a while.
Which means
updates to some fields within that table.

run "select * from table", takes around 4.8 seconds

do a backup & restore of the database

run "select * from table", takes around 0.3 seconds

he plan shows a natural scan in both cases, no other database usage

Nick Upson, Telensa Ltd

[Non-text portions of this message have been removed]