Deleting Computer from SQL Database

[NeilL]

Hi,

I was wondering if there was a way to delete 1500+ computer that belong to a certain domain through the back end (SQL Script). The reason why I'm asking is it taking an average of 2 minutes to delete a computer using the Lansweeper Configuration and when ever I do that sql server just eat the crap out of my memory going from say 4 Gb to up 7.5 Gb bring the server down to a crawl. Nobody can then access the lansweeper from the web.

Any help in this would be great.

Thanks Neil

[Hemoco]

Is your sql server set to "full logging" if yes, change it to "simple", this will make it a lot faster.

SQL script:

delete from tblcomputers where domain = 'mydomain'