Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2005
    Posts
    1

    Question Unanswered: How to put a all database in memory

    Hello,

    I have daily batch that use a tempory database.
    I want to put the all database in memory for more performance.
    I'm on Linux with ASE 12.5.2.

    perhaps i can put it in tempdb, but how i put tempdb in RAM.

    Thank you for your response.

    Sorry for my poor english.

    Jean-Paul

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208

  3. #3
    Join Date
    Jan 2003
    Location
    Geneva, Switzerland
    Posts
    353
    You can use a RAM disk, or use a tmpfs filesystem as mentioned in the FAQ that Willy pointed to.

    However, in recent versions of ASE tempdb uses a "lazy write" algorithm, so if the tempdb cache is large enough disk writes will be minimized.

    So I personally recommend placing tempdb on a device with "dsync" set to false, and then defining a fairly large memory cache dedicated to tempdb. This will minimize writes to the tempdb device, is simple to set up, and should give quite good performance.

    Michael

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •