i have usually opted for dropping the table instead of delete rows so far i know that even if you delete the row the size of the $$$ file stays the same and then if you repopulate again it would increase Razzak am i right about this, please give your unmatchable thoughts on this
Mohammed Sattar Dhaka, Bangladesh > On 20 May, 2018, at 10:19 PM, 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.
