which operation is quicker

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ben - 01 Sep 2005 17:05 GMT

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

Signature

Reply to this Message

Alex Dybenko - 01 Sep 2005 18:32 GMT

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

Signature

Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

> Hi all,
>
[quoted text clipped - 11 lines]
>
> Ben

Reply to this Message