Your suggestion was to reconstruct the index from original
table data on a rollback. For a large transaction that touches
most pages of the index, this can give (at best) a 2:1 speedup.
But the other side, the potential slowdown is extreme.
Yeah, there is that drawback. Other DBMSs avoid
- Forwarded by Ben Carlyle/AU/IRSA/Rail on 04/11/2003 02:26 PM -
Ben Carlyle
04/11/2003 02:01 PM
To: Doug Currie [EMAIL PROTECTED]
cc:
Subject:Re: Re[2]: [sqlite] Performance problem
Doug Currie [EMAIL PROTECTED]
03/11/2003 05:39 AM
Please