Re: Update withou transaction log?

No, this is not possible. Have you tried to split up the update in smaller
transaction, for example by setting 'set rowcount 10000'? (assuming the
update somehow knows how to continue where it left off)? Otherwise you could
use a cursor and commit every X rows.
It may also be useful to check the rules for index usage for direct/deferred
updates, since this can make a big difference for the amount of log space
used (see the ASE Performance & Tuning Guide for details).

HTH,

Rob
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5 / TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase Replication Server Quick Reference Guide"
"The Complete Sybase ASE Quick Reference Guide"

mailto:rob@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------

<jaroslav.povolny@xxxxxxxxx> wrote in message
news:1142342719.478635.316360@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello All,

is there a possibility to make Sybase update WITHOUT writing to
transaction log?
I have to update very large table (where I know there is only one
user).
I am filling the log always, but I do not want to increase the size of
the log,
as it is huge already.

Is there any solution to "turn off" transaction log for some updates,
or even databases?

Thank you

Jaroslav



.

Relevant Pages

  • Recent updates at www.sypron.nl
    ... My books about ASE and RepServer are still are still very popular ... - "The Complete Sybase Replication Server Quick Reference Guide" ... Tricks & Recipes for Sybase ASE" ...
    (comp.databases.sybase)
  • Recent updates at www.sypron.nl
    ... 'purple book' "The Complete Sybase ASE Quick Reference Guide" ... - "The Complete Sybase Replication Server Quick Reference Guide" ... Tricks & Recipes for Sybase ASE" ...
    (comp.databases.sybase)
  • Re: begin tran issues
    ... Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0 ... "The Complete Sybase ASE Quick Reference Guide" ... begin transaction statement that in order for the transaction to be ... If I run this whole statement and then run a rollback statement the ...
    (comp.databases.sybase)
  • Re: Round-off of a float column
    ... Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0 ... "The Complete Sybase Replication Server Quick Reference Guide" ... "The Complete Sybase ASE Quick Reference Guide" ... amount: 67032.1234 => 67032.1234 ...
    (comp.databases.sybase)
  • Re: sp_hidetext
    ... Rob Verschoor ... Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0 ... "The Complete Sybase Replication Server Quick Reference Guide" ... "The Complete Sybase ASE Quick Reference Guide" ...
    (comp.databases.sybase)