An option to create a memory region for logical device creation

[renzo....@gmail.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.

[Rob V [Sybase]]

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:r...@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., Amersfoort, The Netherlands
Chamber of Commerce 27138666
-----------------------------------------------------------------

<renzo....@gmail.com> wrote in message
news:f8ecb8ac-3642-429c...@f1g2000prb.googlegroups.com...