Subject | Re: Please. A solution with TRANSACTIONS for multiple inserts |
---|---|
Author | Aage Johansen |
Post date | 2002-02-03T19:45:52Z |
You wrote:
I don't understand when you say that using ONE SINGLE TRANSACTION IB
uses a simple compression. I supposse IB_transaction1 in my program
is a Single Transaction.
-----------
Transaction and compression is not related. What I meant so say was:
1. Do all inserts into the table using one transaction (don't use autocommit).
2. There is some simple compression of data (done by IB/Fb) - you may (or
may not) benefit of this (space-wise).
Regards,
Aage J.
I don't understand when you say that using ONE SINGLE TRANSACTION IB
uses a simple compression. I supposse IB_transaction1 in my program
is a Single Transaction.
-----------
Transaction and compression is not related. What I meant so say was:
1. Do all inserts into the table using one transaction (don't use autocommit).
2. There is some simple compression of data (done by IB/Fb) - you may (or
may not) benefit of this (space-wise).
Regards,
Aage J.