Re: dbspaces for Temporary tables

Jay Walters wrote: > > I am running IDS 7.3 on NT sp 3 24x7 web OLTP environment. Do people > use onspace -t type dbspaces in this environment (no mirroring?), > regular dbspaces, or filesystem (no mirroring on NT Wks) for their temp > tables. I don't have a lot of disk spindles to play with either > unfortunately. I'm going to be lazy (quiet at the back :) on this and cut&paste a previous reply I made on a similar subject: I'm sure you know most of this, but just to recap. The types of temporary object are as follows: Temporary files: ORDER BY or GROUP BY in a SELECT statement UNIQUE or DISTINCT in a SELECT statement Sort merge join Index builds Temporary tables: Implicit (SELECT INTO TEMP) Explicit (CREATE TEMP TABLE) BLOB values are passed from and to stored procedures and used as global variables These are stored based on the following precedence: Temporary files: PSORT_DBTEMP environment variable DBSPACETEMP environment variable DBSPACETEMP configuration variable /tmp Temporary tables: DBSPACETEMP environment variable DBSPACETEMP configuration variable Root dbspace or dbspace where the database was created Temporary dbspaces listed in DBSPACETEMP can only be used if the table is NOT logged. Notice also that DBSPACETEMP is a list of DBSPACES, NOT directories. Notice also that temp tables can only be stored in a DBSPACE. ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ I am not too sure about PSORT on NT because _fortunately_ I am not familiar with NT. :-) Always create temp dbspaces, even if you are short on spindles. Hope that helps, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com http://www.informix.com/idn |///// / //| |http://www.iiug.org +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 838250 2325 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+