Re: fetching from tempdbs

Hi, you may want to use the "SET EXPLAIN ON;" statement to find out, how exactly the table is accessed. If there's an index can be used to get the data in the desired order, then usually the index will be used rather than sorting in temporary (db)spaces ... Other than that see Art's comments Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management owner-informix-list@iiug.org wrote on 28.01.2005 18:46:31: > Floyd Wellershaus wrote: > > Please do not post MIME or multiple display types. > > > We are selecting 500,000 rows into a a cursor, with an order by, then processing > > those rows with by fetching them and doing work with them. > > > > I assume our tempdbspaces are being used for this. > > The performance gets better and better as the number of rows processed increases. > > Our developers want to know why this is happening ? > > Any ideas ? > > Please be more specific. What do you mean by 'The performance gets better > and better as the number of rows processed increases.'? Do you mean that if > the temp table is larger performance improves? Or that after processing > 10000 out of 500000 speed increases then increases again as you process the > 20000th row etc? > > Art S. Kagel sending to informix-list