Erwin Craps - IT Helps
Erwin.Craps at ithelps.be
Wed Mar 30 09:22:21 CST 2005
I have a weird thing gooing on over here (and it's not a virus). Since a couple of days I notice that most of my databases are pretty slow. When opening a form it builds the screen in 3 or 4 pieces. It seems to hang an instant on the combo boxes when it has to catch data. So I started to pin-point where the delay is caused. So I deactivated my virusscanner and it was instantly faster... I hear some "aha yes thats the virusscanner on MDB files" coming my way, but wait until I finished explaining. My McAfee (Enterprise V8.01i) scanner is configured to exclude MDB, MDE, MDB, MDW and LDB files, from the status window I can see that these files are not scanned (neither on my notebook nor server). But I do notice the scanner is scanning the file 00000001 in the Windows\CSC folder about 130 times while opening the form. I know that the CSC folder is the folder where the files from off-line folders reside. All pretty logical until now. Both my access front and back end reside on the server and are NOT in a folder that is not synchronised. Infact only some website (development) stuff is synchronised. So i ask myself, Why is windows opening that file 130 times when opening a form, while my database is not in a synchronised folder? The database folder is however located in the same share. for example My database is in \\SERVER\APPL\database and some folders are set off-line like this \\SERVER\APPL\folderx \\SERVER\APPL\foldery \\SERVER\APPL\folderz When i turn off off-line folders my speed is normal. So now I can exclude extension less files from virusscanning or maybe the whole CSC folder. That will limit the lost time while virusscanning but the file 00000001 will still be opened 130 time when opening a form. Maybe this will ring any bells with other people that experianced slow downs on opening forms. Erwin Craps Zaakvoerder www.ithelps.be/onsgezin This E-mail is confidential, may be legally privileged, and is for the intended recipient only. Access, disclosure, copying, distribution, or reliance on any of it by anyone else is prohibited and may be a criminal offence. Please delete if obtained in error and E-mail confirmation to the sender. IT Helps - I.T. Help Center *** Box Office Belgium & Luxembourg www.ithelps.be <http://www.ithelps.be/> * www.boxoffice.be <http://www.boxoffice.be/> * www.stadleuven.be <http://www.stadleuven.be/> IT Helps bvba* ** Mercatorpad 3 ** 3000 Leuven IT Helps * Phone: +32 16 296 404 * Fax: +32 16 296 405 E-mail: Info at ithelps.be Box Office ** Fax: +32 16 296 406 ** Box Office E-mail: Staff at boxoffice.be <mailto:figures at boxoffice.be>