Re: [GENERAL] transaction toggling

2005-10-05 Thread Jim C. Nasby
On Wed, Oct 05, 2005 at 12:49:33AM -0700, Matthew Peter wrote: > Is there a way to disable transactions on certian > queries? I read a while back that this wasn't > possible, just wondering if it is in 8.1 or planned in > the future? > > Does it even make a dent in the performance if a query > is

Re: [GENERAL] transaction toggling

2005-10-05 Thread Matthew Peter
--- Richard Huxton wrote: > Matthew Peter wrote: > > Is there a way to disable transactions on certian > > queries? I read a while back that this wasn't > > possible, just wondering if it is in 8.1 or > planned in > > the future? > > > > Does it even make a dent in the performance if a > query

Re: [GENERAL] transaction toggling

2005-10-05 Thread Richard Huxton
Matthew Peter wrote: Is there a way to disable transactions on certian queries? I read a while back that this wasn't possible, just wondering if it is in 8.1 or planned in the future? Does it even make a dent in the performance if a query is wrapped in a transaction instead of out? Such as a v

Re: [GENERAL] transaction toggling

2005-10-05 Thread Martijn van Oosterhout
On Wed, Oct 05, 2005 at 12:49:33AM -0700, Matthew Peter wrote: > Does it even make a dent in the performance if a query > is wrapped in a transaction instead of out? Such as a > view counter, like... > > update views = views + 1 where x = 1;? All statements are within a transaction. The question

[GENERAL] transaction toggling

2005-10-05 Thread Matthew Peter
Is there a way to disable transactions on certian queries? I read a while back that this wasn't possible, just wondering if it is in 8.1 or planned in the future? Does it even make a dent in the performance if a query is wrapped in a transaction instead of out? Such as a view counter, like... up