Hi all,

I solved my problem. I create a index to table DUP.

Thanks

> ----- Mensagem original -----
> De: Marcelo Pitanga [SMTP:marcelopitanga@...]
> Enviada em: terça-feira, 22 de abril de 2003 11:29
> Para: 'ib-support@yahoogroups.com'
> Assunto: [ib-support] client freeze when execute statement
> delete
>
> Hi all,
>
> I've the following statement:
>
> delete from REV where cod in ( select cod from DUP ).
>
> REV has 450000 records
> DUP has 3635 records
>
> When i execute this statement my client freeze after some time. I forced a
> shutdown by Guardian and when i open your log the following messages is
> registered.
>
> DES213 (Server) Tue Apr 22 10:46:59 2003
> Database: C:\SPE\Spe.fdb
> internal gds software consistency check (Too many savepoints (287))
>
> DES213 (Client) Tue Apr 22 10:47:00 2003
> C:\firebird15\bin\fbserver.exe: normal shutdown
>
> my configuration:
>
> DELL PIII-700mhz - 128MB - HD 10Gb free.
> Windows ME 4.90.3000
> Firebird 1.5 RC1 - 1.5.0.3233
> IB Expert Personal Edition 2.5.0.22
>
> what happened?
>
> Thanks in advanced
> Marcelo
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>