A couple of suggestions, 1. Check to see how busy the server is that shares the database. If there server is too busy it will slow down the access times for everyone. 2. Use good quality switches. HP,Cisco, Foundry, 3com(now hp). Stay away from the home based vendors (linksys, dlink, netgear, belkin) (This is from personal experience. I used to use Netgear prosafe switches and my database would get corrupt every 1-3 months at random. Switched to 3com switches and have not had a corruption since.) (I also only use gigabit nics/switches, time is money and it is a big difference running gigabit vs 100 mb!!) 3. Make sure your AV is not a resource hog. Mcafee and Norton are notorious for this. 4. Memory - Over the years Windows XP keeps adding patches and service packs which take up more ram. When XP first came out you could run it decently on 256 mb, then when service pack 2 came out it changed to 512 mb. Now with service pack 3, security patches, AV, and other programs 512 mb is not enough. You will notice the physical memory drop under 50 mb, which is bad. Dan Goldberg
_____ From: [email protected] [mailto:[email protected]] On Behalf Of MDRD Sent: Tuesday, July 13, 2010 7:32 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Off Topic ... Suggestion for networks It seems non RBase things can slow down a network and if someone uses RBase 99% of the time they think RBase is slow on a network or really I should say my App is slow. Recently my home and work computer would loose connection with the Internet after about 2 hours, I could still receive Emails but IE could not find the web. I had to reboot the computers to re connect with the web. Then I uninstalled Ad-Aware and all my problems went away! Last night I was at Boy Scouts and talking to 2 computer dads, both said the same well knows AV software will drag their computers down to a crawl, even when it is set to Not scan their DB folder and files. One of the dads works at a major corp in our town. So, I would like to develop a flow chart to send users. We could expand this list to include suggestions for data corruption too Before you call for tech support ** if you are not using 1 Gig network cards and switch.... that may be the problem, too much 1) Reboot your computers 2) If you have more than 1 workstation try the same thing on the other workstation and compare the speed 3) shut down your AV 4) Stop playing music on your computer .... LOL 5) take your coffee cup out of the coffee cup holder 6) Run ScanDisk and Defrag 1x a month 7) Run CCleaner to clean out old junk files 8) do not run your Cat 5 cables on top of fluorescent lights 9) Use battery backups on all computers... ... .... 99) now call me if you need help! Thanks for any suggestions Marc
