Re: Turning off transactions completely.

On Sat, Jan 05, 2002 at 02:21:44PM +0530, Arsalan Zaidi wrote:
> Hi.
>
> I'm writing a very specialised app which has absolutely NO need for
> transactions. However, I have to milk every drop of performance out of it
> cause I'm performing some fairly complex queries on tens of millions of
> rows.
>
> Is there any way I can completely avoid the overhead of the implicit
> transaction per SQL statement? Is there some switch or some (fairly easy)
> editting that can be done to the code? My transaction log files often reach
> 800 MB in size and I'd like to avoid the overhead if at all possible...

Well, every statement must be within a transaction, so to reduce the number
of transactions start one explicitly and commit when you're done. Then you
only have one transaction for the whole thing.

HTH,

--
Martijn van Oosterhout <kleptog@svana.org>
http://svana.org/kleptog/
> Terrorists can only take my life. Only my government can take my freedom.