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.

An option to create a memory region for logical device creation

2 posts in Product Futures Discussion Last posting was on 2009-04-06 08:22:19.0Z
renzo.aquino Posted on 2009-04-06 06:21:03.0Z
From: renzo.aquino@gmail.com
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: An option to create a memory region for logical device creation
Date: Sun, 5 Apr 2009 23:21:03 -0700 (PDT)
Organization: http://groups.google.com
Lines: 18
Message-ID: <f8ecb8ac-3642-429c-9d96-9bb75e70913a@f1g2000prb.googlegroups.com>
NNTP-Posting-Host: 124.105.216.124
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1238998864 20471 127.0.0.1 (6 Apr 2009 06:21:04 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 6 Apr 2009 06:21:04 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: f1g2000prb.googlegroups.com; posting-host=124.105.216.124; posting-account=tGPBogoAAADskRZsAjqsJ5xZWzZ8rxax
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.8) Gecko/2009032609 Firefox/3.0.8,gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.yul.equant.net!nntp1.roc.gblx.net!nntp.gblx.net!nntp.gblx.net!nlpi057.nbdc.sbc.com!prodigy.net!border1.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!f1g2000prb.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:2022
Article PK: 97621

Memory now a days comes very cheap. I hope Sybase can have an option
to create a memory region for logical device creation and the said
logical device will be use for dynamic databases like tempdb.

use master
go
mem init name='memdev1_dat',memsize='4000mb'
go
mem init name='memdev1_logt',memsize='1000mb'
go
alter database tempdb on memdev1_dat=4000 log on memdev1_log=1000
go

This will be a very fast throughput.


Rob V [Sybase] Posted on 2009-04-06 08:22:19.0Z
Reply-To: "Rob V [Sybase]" <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
From: "Rob V [Sybase]" <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Newsgroups: sybase.public.ase.product_futures_discussion
References: <f8ecb8ac-3642-429c-9d96-9bb75e70913a@f1g2000prb.googlegroups.com>
Subject: Re: An option to create a memory region for logical device creation
Lines: 49
Organization: Sypron BV / TeamSybase / Sybase Inc
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49d9bbbb@forums-1-dub>
Date: 6 Apr 2009 01:22:19 -0700
X-Trace: forums-1-dub 1239006139 10.22.241.152 (6 Apr 2009 01:22:19 -0700)
X-Original-Trace: 6 Apr 2009 01:22:19 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:2023
Article PK: 97622

You can already do something that comes close to this: in the OS, create a
memory-based filesystem (e.g. tmpfs), and then create a database device on
that.
BTW, in 12.5.0.3 or later, for tempdb, it is more efficient to create a
cache in ASE itself, and then bind tempdb to that cache.

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

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

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

mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., Amersfoort, The Netherlands
Chamber of Commerce 27138666
-----------------------------------------------------------------

<renzo.aquino@gmail.com> wrote in message
news:f8ecb8ac-3642-429c-9d96-9bb75e70913a@f1g2000prb.googlegroups.com...
> Memory now a days comes very cheap. I hope Sybase can have an option
> to create a memory region for logical device creation and the said
> logical device will be use for dynamic databases like tempdb.
>
> use master
> go
> mem init name='memdev1_dat',memsize='4000mb'
> go
> mem init name='memdev1_logt',memsize='1000mb'
> go
> alter database tempdb on memdev1_dat=4000 log on memdev1_log=1000
> go
>
> This will be a very fast throughput.
>
>
>
>