Programmatically deleting all records in a table (1 Viewer)

Frothingslosh

Premier Pale Stale Ale
Local time
Today, 04:46
Joined
Oct 17, 2012
Messages
3,276
I have to admit to being curious now as to how long it would take to delete the contents from my biggest table at work via the row-by-row method, but I'm pretty sure it would result in my boss shooting me before firing me. :p And copying the table then running the test on that isn't exactly an option. I'm not even sure we have enough space for me to do that.
 

isladogs

MVP / VIP
Local time
Today, 09:46
Joined
Jan 14, 2017
Messages
18,209
I haven't tried deleting row by row but did try appending row by row (or RBAR as I now call it thanks to Minty)
When I tried the latter on a large table as part of my earlier speed tests, I ran out of system resources or hit the 2GB file size limit!
 

Frothingslosh

Premier Pale Stale Ale
Local time
Today, 04:46
Joined
Oct 17, 2012
Messages
3,276
I believe it.
 

Users who are viewing this thread

Top Bottom