Somewhere back in the dark ages of history I began to drop and recreate. I think the temp table is a $$$ file on the drive, so I think I did it due to possible increase in the size of the $$$ file.
I have no idea whether or not I am correct but I have this code whenever I work with Temp Tables. They seem to take an infinitesimal amount of time to process. SET ERR MESS 2038 off DROP TABLE tmpTableName SET ERR MESS 2038 on CREATE TEMP TABLE …. Albert > On May 20, 2018, at 10:19 AM, Bruce A. Chitiea <[email protected]> wrote: > > All: > > Which is preferable from a speed/memory management perspective: > > a) DROP TABLE humpty_tt, or > > b) DELETE ROWS FROM humpty_tt > > I have a brute-force, iterative process which fills and clears a temp table > (say, humpty_tt) for as many iterations as it takes to produce the desired > result. Possibly LOTS of iterations, several thousand rows per iteration. > > Working RAM capacity is not an issue. > > Thanks > > Bruce A. Chitiea > SafeSectors, Inc. > 909.238.9012 m > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > <http://www.rbase.com/support/usersgroup_guidelines.php> > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
