Silicon Investor (SI) -- The First Internet Community

STOCKTALK

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor. We ask that you disable ad blocking while on Silicon Investor in the best interests of our community. If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.

Politics : Formerly About Advanced Micro Devices -- Ignore unavailable to you. Want to Upgrade?

To: crazyoldman who wrote (120111)	7/11/2000 6:24:25 PM
From: Joe NYC	Read Replies (1) \| Respond to of 1574096

crazyoldman, I think Windows 2000 has improved the multiprocessing compared to NT. I think you would benefit from it especially in the server environment, combined with probably a higher performance and better multithreaded software such as MSFT SQL 7.0. But that is only after you have maxed out on RAM. On a single user workstation, I think it is extremely rare that you would derive any perceptible benefit from more than 1 processor. Joe

To: crazyoldman who wrote (120111)	7/11/2000 6:24:55 PM
From: ericneu	Read Replies (2) \| Respond to of 1574096

The SQL Engine being used was Imprise's Interbase on NT 4.0. As each client establishes a connection with the Interbase server (the SQL database engine located on the NT server), the Interbase SQL server begins a new thread for the client connection. It sounded like a perfect match up for a SMP machine, but the "veteran" who had tried it (whose company laid out big $$$) said it was a waste of money. --- Results like this usually indicate that the application was being throttled by something besides the CPU. If you're experiencing constant swapping to and from disk it's fairly irrelevant how much CPU power you have available. You mentioned that more RAM made a difference - if the additional RAM had been present during the SMP testing the results would probably have been different. Tuning a computer for higher performance is pretty simple. 1. Load the system as per the expected use profile. 2. Find the bottleneck and alleviate it. 3. Repeat starting at step 1 until you run out of money. - Eric