Subject | RE: [firebird-support] Slow stored procedure |
---|---|
Author | Rick DeBay |
Post date | 2004-07-27T16:26:25Z |
Batching and committing ten updates at a time:
sending raw batch...175.24s sending CPR batch...0.1s committing...0.1s
done
sending raw batch...177.36s sending CPR batch...0.1s committing...0.1s
done
I guess the answer is never do updates on a large table without an index
(the raw table has no index, while the CPR table does).
sending raw batch...175.24s sending CPR batch...0.1s committing...0.1s
done
sending raw batch...177.36s sending CPR batch...0.1s committing...0.1s
done
I guess the answer is never do updates on a large table without an index
(the raw table has no index, while the CPR table does).