> deletion of all ~60.000 records - ~500 msec
> select count(*) / * from table (table is completely empty after deletion) ~ 5 minutes !!
>
> After select * or count(*) once is finished (after 5 minutes ^^), every following statement will execute normally ( few msecs ).
> Table is indexed (primary key on integer column).
>
> Whats happening here? Looking at the task manager theres no significant CPU load. The fb client seems to do nothing during
> execution (load of client process ~ 5% / ~20% other / ~75% idle)
> Any suggestions?
>
> Sys specs:
> Athlon64 3400+, 1g RAM, 2x7200rpm SATA Disks @Raid0, Win2000
> Running Firebird 2.1 classic server

Ensure your database in ODS 11.1 (run gstat -h)

Regards,
Vlad