Re: What's the fastest way to...

> > >: C'mon back > > The clock speed and RAM capacity may have an impact on whether "brute > force" or loop method is used. If you are running a 10Mhz system with 4MB > RAM (AT&T 3B2/400), the "brute force" me thod bombs out. I had infinitely > more satisfactory results with a loop. Sorry, I jumped into this rather late. 2million rows effectively kills any thought of using a single UPDATE statement in a logging environment. cheers j. > -- > Harry Caughey | My ability to communicate with you > Virginia Beach, Virginia | is only as good as your ability to > caughey@infi.net | communicate with me. Have a nice day. AND WHAT EXACTLY IS THAT SUPPOSED TO MEAN?! WHAT ARE YOU TRYING TO SAY BUDDY? _____________________________________________________________________________ Jack Parker | Hewlett Packard, BSMC Boise, Idaho, USA| If you put all of the lawyers in jparker@hpbs3645.boi.hp.com | this country end to end, (208) 396-5388 (W) (208) 384-1623 (H) | it would be a good thing. _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________