To: Joe NYC who wrote (30021 ) 10/28/1998 4:31:00 AM From: Craig Freeman Read Replies (1) | Respond to of 33344
Jozef, re: "No disk access. The entire database fits in the disk cache of the server." During the 486 era, I tested several Novell networks and discovered that it can take longer to "lock" a record than to load it .. even with unlimited server cache. There are lots of ways Novell can lock records but the most common method is SLOOOW. If your software erroneously issues extraneous locks, it will run slowly no matter what kind of CPU, O/S or file server in use. Under NT, if you are the only user then it automatically performs "local caching" which eliminates the need for all locks. Novell lacks this ability. Therefore, with identical workstations and server hardware, a Novell network may provide around ~600KBS throughput while an NT server can provide 12,000KBS throughput with a typical 300MHz CPU. To some, that means that "NT" is 20 times faster than Novell. Wrong! The instant you add another station addressing the same file, Novell starts to rev and NT dies down. As you add stations, the benchmarks change according to more causes than I could possibly explain here. And while NT can be futzy, Novell 3.12 is absolutely bulletproof (no comment here on Novell 4x+). Unless you are VERY careful, network benchmarks can be totally meaningless. About all that you can be sure of is that if you are the only user on a network, a cached read or a write into server cache should take place at 60-90% of the theoretical network speed (600-900KBS for 10BaseT, around 6,000KBS for 100BaseT). The usual test is to open a DOS box and locate a file of a MB or more. Type COPY C:xxxx F:\ and see how long it takes before your prompt returns. Anything fancier -- like TPS testing is ... well ... fancier but not necessarily meaningful. Craig