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...
Thanks in advance.
--Arsalan.
-------------------------------------------------------------------
People often hate those things which they do not know, or cannot understand.
--Ali Ibn Abi Talib (AS)