which operation is quicker

B

Ben

Hi all,

I would like to ask which operation is faster:
1) drop table...
select .... into tblX or

2) delete records in tblX
append recs into tblX

I would think it is (1), but not sure if simply take the time of before and
after is sufficient. Which way s faster and how would one benchmark it
correctly? Thanks for sharing your thoughts.

Ben
--
 
A

Alex Dybenko

Hi,
if there is no indexes in tblX - then i think almost the same, else first
will be faster
you can build a look of say 20-30 operation and then measure time spent.
just get Now() before loop into some variable, and then compare it to Now()
after the loop
 
Top