Subject Re: [firebird-support] Re: Work tables, can affect FB performance?
Author Ann W. Harrison
bill_lam wrote:
> Ann W. Harrison wrote:
>> In this case you will run into trouble if you drop and recreate
>> "thousands" of tables a day. There's a 16 bit number that represents
>> the table id and the numbers aren't reused.
>
> Can a gbak backup/restore help to prevent table id being run out?

Yes. A gbak restore resets table identifiers.


Regards,


Ann