Re: Array vs Temporary Tables, benchmark testing

["Fetzik, John" <JFetzik@SANDC.COM>]

Greetings,

Other considerations are the amount of data you are working with, the
'horsepower' of the PC you are working on and the 'horsepower'. If you have
a LARGE amount of data for your temporary tables/arrays AND you will be
running the SQR on a really slow PC, like the P90's we have, you might want
to have the database server do some of the grunt work.

Now most PC's have more then enough 'horsepower' for the number of rows that
are typically considered temporary data. Thus arrays are usually going to be
the more speedy choice.


John S. Fetzik


-----Original Message-----
From: Rick Creel [mailto:Rick_Creel@AONCONS.COM]
Sent: Tuesday, September 14, 1999 9:06 AM
To: Multiple recipients of list SQR-USERS
Subject: Re: Array vs Temporary Tables, benchmark testing


There may not be any built in sort functions with arrays, but you could
write a
routine to do an old fashion "bubble sort" on the array.  Since arrays are
memory resident, I would tend to agree that arrays would be much faster than
a
temp table.