| Subject | Re: [firebird-support] Why drop table can be sometime very very long ? |
|---|---|
| Author | Vander Clock Stephane |
| Post date | 2011-08-30T18:56:10Z |
On 8/29/2011 9:44 AM, Thomas Steinmaurer wrote:
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]
>no, the database have only one client connected, the client that do the
> > 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?
>
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]