Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


New computer - Need advise:

Posted on 1999-07-17
Medium Priority
Last Modified: 2010-04-27
I'm thinking of buying a new computer
and I need some advise.

I need a high performance PC with NT Workstation.
I will primarily be running heavy MS Access Queries.

I'm not that updated on the current Intel CPU's.
Pentium II, Pentium III, Xeon and dual CPU's.

Which CPU is best for me?
Is the Xeon worth the price?
Does two CPU's give me a 100% more CPU resources.

I thought of a 256 MB of RAM and a fast harddrive.
Question by:ola
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 15

Accepted Solution

Tommy Hui earned 800 total points
ID: 1159449
Dual CPUs are only useful if you are using NT. If you want to use Windows 9x, the second CPU is useless. Since you are planning to use NT, NT's scheduler will be able to use the second CPU efficiently. However, it is still up to the application to spawn threads to do CPU intensive things. Unfortunately, Access isn't one of them. The Jet database engine does not execute queries in parallel. So if all you are doing is Access, the second CPU may not be that much of a gain.

But if you run more than one program at a time, then you will find that having two CPUs is better than having one. The response time is quicker and it feels like NT is running more smoothly. But two CPUs does not always mean twice the speed of one CPU. NT still has to spend time switching contexts for the CPUs.

The Pentium III is a very good chip for its price. You can get a dual Pentium III system for fairly cheap. I would recommend this setup over anything else for price/performance/value reasons. I would also recommend you get at least 128MB of RAM. If performance is a must, go with SCSI and a fast video card.


Author Comment

ID: 1159450

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Moving your enterprise fax infrastructure from in-house fax machines and servers to the cloud makes sense — from both an efficiency and productivity standpoint. But does migrating to a cloud fax solution mean you will no longer be able to send or re…
This article will show how Aten was able to supply easy management and control for Artear's video walls and wide range display configurations of their newsroom.
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question