Using MS Access 2000 on Win2k IIS5.0 server, with

Network Associates NetShield anti-virus software

installed...



I have daily database updates that are scheduled to

run every morning.  These updates usually take about 2

hours to complete.  However, we recently installed

said virus protection, and now when the scanner is

running the updates take 5+ hours to complete!  There

aren't any errors, it just takes frakkin' forever.



Has anyone else come across this problem, and found a

work-around/solution besides disabling the virus

software (which is what I've been doing)?



And here's a question I thought I knew the answer

to...

Is it even a good idea to have virus software on a

production server?  Because nothing will be installed

on the machine without extensive testing beforehand,

and no-one uses for e-mail or anything stupid like

that.  Plus it's behind a firewall (actually, it's

behind two) that has it's own scanning software for

network traffic...  So should we take off the virus

software?  I think so... but I would need to present a

"business case" to my boss to convince him it's safe.



thanks fer yer help.



 - mike



__________________________________________________

Do You Yahoo!?

Yahoo! Auctions - buy the things you want at great prices

http://auctions.yahoo.com/

>I have daily database updates that are scheduled to

>run every morning.  These updates usually take about 2

>hours to complete.  However, we recently installed

>said virus protection, and now when the scanner is

>running the updates take 5+ hours to complete!  There

>aren't any errors, it just takes frakkin' forever.



Try tuneing up your aplication and database (db), by this y mean try using 

prue sql language, adding some indexes on some fields in your db to speed up 

your querys, insted of using the recordset functions find and filter try 

using sql staments, believe it or not the work alot faster, if you connect 

to the database via odbc try using OLEDB y a bit faster.



>Is it even a good idea to have virus software on a

>production server?  Because nothing will be installed

>on the machine without extensive testing beforehand,

>and no-one uses for e-mail or anything stupid like

>that.  Plus it's behind a firewall (actually, it's

>behind two) that has it's own scanning software for

>network traffic...  So should we take off the virus

>software?  I think so... but I would need to present a

>"business case" to my boss to convince him it's safe.



i'd suggest to leave your antivirus software remeber a co worker my try to 

harm you or the companies computer.



my 2 cents



---

Jose Erasmo Valladares

jevalladares@h...



_________________________________________________________________________

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.