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 t 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]
