Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - 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
X-Original-NNTP-Posting-Host: 192.216.135.8
Message-ID: <3f4b7dfb@forums-2-dub>
X-Original-Trace: 26 Aug 2003 08:34:19 -0700, 192.216.135.8
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 26 Aug 2003 08:32:09 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 26 Aug 2003 08:33:32 -0700
X-Trace: forums-1-dub 1061912012 10.22.108.75 (26 Aug 2003 08:33:32 -0700)
X-Original-Trace: 26 Aug 2003 08:33:32 -0700, forums-master.sybase.com
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" <rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
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
NNTP-Posting-Host: a66085.upc-a.chello.nl
X-Original-NNTP-Posting-Host: a66085.upc-a.chello.nl
Message-ID: <3f4b8050$1@forums-1-dub>
Date: 26 Aug 2003 08:44:16 -0700
X-Trace: forums-1-dub 1061912656 62.163.66.85 (26 Aug 2003 08:44:16 -0700)
X-Original-Trace: 26 Aug 2003 08:44:16 -0700, a66085.upc-a.chello.nl
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 12.5.0.3 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 http://www.sypron.nl/shop

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