Needs of Multi-Core
"Your 12 core..... for dozens of cycles." by Henry Cobb
Well it's true that the on/off switch here does matter. Personally, I've done a lot of testing on many computers, laptops and servers with most of the common processor models. Ranging from old 386 series to quad-core Xeon, from old K6/2 AMD till Turion. What Henry had told here is a fact. Most of our computer when running on daily used programs like MS Office, Windows, Media Players, Internet Browser and so on, actually rely more on inter hard drive and ram transfer. Most of our time spent waiting for a program to load, was time being spend seeking data and state module processing. In average, generally none of our computer workload reach even 50 percent if you'd ever calculated. So, multi-core doesn't seem to be a very critical technology to us.
It's more to those who need data processing and calculation power. Example, folding@home or earth stimulation. These computing tasks could work with very little or fixed set of data while used up all processing power all time until they get the job done. Therefore, data transfer rate between ram and processors, core between core had played a very critical role. If you'd run folding@home or any similar grid-computing software, you'll find that these software had been designed to run separately on individual core. Well, honestly, it does bring a number of benefits.
"Anyone any experience with this?" BY Matt
Currently, I've a few database in-house from MS SQL and Oracle. Databases doesn't require too much processing power unless they need to do some calculation. What they'll need is HDD and ram access bandwidth which include HDD data seek time, transfer bandwidth, ram access latency, and overall system I/O handles. The larger the database and query range, the longer time it takes to dig-out data you required. The database vendor could have told you that their database system can run or process 32/64 or maybe more and more query at a time, but don't forget one thing, if the database was stored on a single HDD, single channel ram, then you'll might as well forget about the simultaneous job handler. And even if you have the server running on raid-5 with 6 or more high speed SAS/SCSI HDD, the maximum I/O and transfer latency between Storage controller and ram/processor will limit your performance too.