i thought i have seen it all about resource eaters

[Luis G]

But this SQL Server 2000 is just a resource hog, this is what inserting around 20000 registers to the database does to your puter.

Note, you might think 20000 registers of "what", all of them are text or numeric, no register is bigger than 200bytes.

 

[Luis G]

After a few minutes...

Also, notice the peak commit value.

 

[Professur]

db2 rocks

 

[Luis G]

It seems that problems went away when i used ODBC to do the task, the normal load with sql server running is of about 150MB, and when the program inserted the registers via ODBC the load went up to 230MB, which is still not good, but it is far more acceptable than 650MB.