Re: loading a table more efficiently...

Yes, we notice about a 30% performance hit by using dbspaces for this, but then, raid5 (don't shoot me anyone, it managers policy), zip on the temp disk I wrote to. Problem is that the O/S takes a big hit aswell writing to a filesystem, my recommendation, take the performance hit and write to temp dbspaces, that way your machine doesn't grind when some idiot does something evil because they are using a pretty gui and don't have a clue brett > I've heard some people say that causing the engine to use external files for > sorting during index builds is quicker, but that's flatly contradicted by > the performance tuning manuals. Perhaps it depends on the ----------------------------------------------------------------- Brett's 13th law of UNIX administration... The 13th sucks, we'll skip this one ----------------------------------------------------------------- Brett Geer - UNIX Admin/Analyst/Programmer - Intratex Holdings. Tel. +27 31 717 4000 Direct. +27 31 717 4146 Fax. +27 31 717 4001 ----------------------------------------------------------------- The little voices are talking to me again, telling me of a long forgotten rhyme... the Rhyme of the Ancient Sysadmin # ps -ef | kill -9 `awk '/albatross/{print $2}'` -----------------------------------------------------------------