Re: High lngspins - IDS 9.30 UC2

Hari Gupta wrote: > Thanks Mark. I love your comments and sharp observation. Thanks. So YOU'RE the one. :-) > Performance is an issue but not crirical. Okay. So you were just fishing for improvements. > Regd. tempdbs, if I create another temp > dbspace, you reckon, it will help in hammering down. I would like to see at least three on any system, especially one making heavy use of temp tables. Preferably on different disks. Although that may be difficult with your striping. Quite often you will read all records from a temp table, so sequential scans in that instance are not bad. However, for more filtered queries from large temp tables, you can also look at creating indexes on them. The additional overhead may be far less than the sequential scan. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+ sending to informix-list