[PERFORM] Various Questions

2003-12-01 Thread Evil Azrael
Hi! I have 4 question which probably someone can answer. 1) I have a transaction during which no data was modified, does it make a difference whether i send COMMIT or ROLLBACK? The effect is the same, but what´s about the speed? 2) Is there any general rule when the GEQO will start using an ind

Re: [PERFORM] Various Questions

2003-12-01 Thread Andrew Sullivan
On Mon, Dec 01, 2003 at 02:07:50PM +0100, Evil Azrael wrote: > 1) I have a transaction during which no data was modified, does it > make a difference whether i send COMMIT or ROLLBACK? The effect is the > same, but what´s about the speed? It makes no difference. > 2) Is there any general rule whe

Re: [PERFORM] Various Questions

2003-12-01 Thread Shridhar Daithankar
On Monday 01 December 2003 18:37, Evil Azrael wrote: > 1) I have a transaction during which no data was modified, does it > make a difference whether i send COMMIT or ROLLBACK? The effect is the > same, but what´s about the speed? It should not matter. Both commit and rollback should take same amo

[PERFORM] Various Questions

2003-12-01 Thread Evil Azrael
Hi! I have 4 question which probably someone can answer. 1) I have a transaction during which no data was modified, does it make a difference whether i send COMMIT or ROLLBACK? The effect is the same, but what´s about the speed? 2) Is there any general rule when the GEQO will start using an ind