Temp dbspace in RAM

Posted in 2007

RUSTEM GISATULLIN — Tue, 10 Apr 2007 09:05:42 — source: IIUG Forums & Mailing Lists

Please tell me how to create temp dbspace in RAM. It will be good if your suggestion was for Unixware7

↪ replying to RUSTEM GISATULLIN

Jonathan Leffler — Tue, 10 Apr 2007 15:52:25 — source: IIUG Forums & Mailing Lists

On 4/10/07, RUSTEM GISATULLIN <rustem@icl.kazan.ru> wrote: > Please tell me how to create temp dbspace in RAM. It will be good if your > suggestion was for Unixware7 Why would you want to do that? I think you'd be better off allocating the spare RAM as extra buffers etc, and letting the system use disk space for the temp dbspace. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2007.0226 -- http://dbi.perl.org/ NB: Please do not use this email for correspondence. I don't necessarily read it every week, even.

↪ replying to Jonathan Leffler

RUSTEM GISATULLIN — Wed, 11 Apr 2007 05:21:09 — source: IIUG Forums & Mailing Lists

Hi, Jonathan The server works as mix of OLTP and OLAP systems and there are many operations with temp dbspaces (I can see that) . So I'd like to try another technique to speed up 'temporary' actions.

Glossary

dbspace