Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Tempdb Logging

2 posts in Product Futures Discussion Last posting was on 2003-08-26 15:44:16.0Z
BSB Posted on 2003-08-26 15:33:32.0Z
From: "BSB" <ss>
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Tempdb Logging
Lines: 3
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <3f4b7dfb@forums-2-dub>
X-Original-Trace: 26 Aug 2003 08:34:19 -0700,
X-Original-Trace: 26 Aug 2003 08:32:09 -0700,
Date: 26 Aug 2003 08:33:32 -0700
X-Trace: forums-1-dub 1061912012 (26 Aug 2003 08:33:32 -0700)
X-Original-Trace: 26 Aug 2003 08:33:32 -0700,
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1344
Article PK: 95582

Why not have the option to turn off loggin on tempdb?

Rob Verschoor Posted on 2003-08-26 15:44:16.0Z
From: "Rob Verschoor" <>
Newsgroups: sybase.public.ase.product_futures_discussion
References: <3f4b7dfb@forums-2-dub>
Subject: Re: Tempdb Logging
Lines: 23
MIME-Version: 1.0
Content-Type: text/plain; charset="Windows-1252"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <3f4b8050$1@forums-1-dub>
Date: 26 Aug 2003 08:44:16 -0700
X-Trace: forums-1-dub 1061912656 (26 Aug 2003 08:44:16 -0700)
X-Original-Trace: 26 Aug 2003 08:44:16 -0700,
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1346
Article PK: 95583

"BSB" <ss> wrote in message news:3f4b7dfb@forums-2-dub...
> Why not have the option to turn off loggin on tempdb?

Well, some peope want to do transactions and triggers in tempdb...
Anyway, the lazy-write-on-commit in tempdb in is probably
what you're lookign for: this greatly improves tempdb performance...

Rob V.
Rob Verschoor

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

Author of "Tips, Tricks & Recipes for Sybase ASE" and
"The Complete Sybase ASE Quick Reference Guide"
Online orders accepted at
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands