Subject | Re: [ib-support] Firebird Backups with Sweep |
---|---|
Author | Svein Erling Tysvær |
Post date | 2002-05-10T13:56:34Z |
>The original table, before deletions, took an average of 25 minutesWhat about your indexes, are each entry close to unique or are there plenty
>to fully backup. The modified table has, so far, taken some 30 hours
>and, extrapolating the current rate forward, looks like it will take
>a further 14-16 hours to complete.
of duplicates for each entry in the index? I don't know where the slowdown
is supposed to take place, but something will take a lot of time if you
have low selectivity indexes. To avoid this pitfall, add the primary key to
the index, e.g. CREATE INDEX idx_continent ON customer(continent, id)
HTH,
Set