Subject Re: [firebird-support] Re: Work tables, can affect FB performance?
Author Ann W. Harrison
Adam wrote:
>> I want to set up work tables, which gets filled and deleted thousands of
>> times each day
>
> Dropping and recreating the table is usually much cheaper, although
> you can run into problems


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.


Regards,


Ann