| Subject | RE: [firebird-support] how to reduce the file size of the database after large amount of deletes ref/eDN8072730811 |
|---|---|
| Author | Alan McDonald |
| Post date | 2006-09-27T22:11:43Z |
> I have check the indexes, there only these that the application wants.make sure that you have not created your own indexes on things like PKs and
>
> I will delete only the records and I will check the speed. I will
> inform you
> about my tests.
>
> Thank you guys for your time.
>
> Dennis
FKs - FN makes it's own and there is a performance degradation if you
duplicate them
Alan