Thunderstone Support Forums

I am using this statement to remove files from database

nohup gw -st -d/u1/data/user "delete from html where Url like
'/abacus.bates.edu'"


I have a large number of files, and this process is taking a long time to
remove files one-by-one


Is there a faster method to remove multiple files?

Thanks

Mike Clark
super@101super.com

It looks like you're deleting by the site name which is the first part
of the url. You can take advantage of the url index my using matches
instead of like:
gw -st -d/u1/data/user "delete from html where Url matches 'abacus.bates.edu%'"