Subject Re: [firebird-support] Why drop table can be sometime very very long ?
Author Vander Clock Stephane
On 8/29/2011 9:44 AM, Thomas Steinmaurer wrote:
> > when i do drop table, sometime it's take hours to return (especially on
> > big table)
> > why ?
> Are you perhaps running the DROP TABLE statement in a transaction with
> the WAIT option, while the table is in use by concurrent transactions?

no, the database have only one client connected, the client that do the
drop table ...
it's not failed, it's just very very long !
as soon as it success, creating again and deleting again the table is
very fast !
i thing it's connected with the number or reccord in the table (in my
case lot of, and lot of index too)

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