Wow, I didn't know that (didn't get far enough to test any rollback). That's not a good thing. <facetious>But then again, it's MySQL who needs rollback anyway?</facetious>

On Feb 2, 2004, at 5:44 PM, Christopher Kings-Lynne wrote:

One more thing that annoyed me. If you started a process, such as a large DDL operation, or heaven forbid, a cartesian join (what? I never do that!).

I believe InnoDB also has O(n) rollback time. eg. if you are rolling back 100 million row changes, it takes a long, long time. In PostgreSQL rolling back is O(1)...


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to