Hi!
Am Fr, den 11.02.2005 schrieb Scott Pippin um 18:55: > What knid of performance difference can I expect between 2 xeon 3ghz > 32bit compared with 2 IBM Power5 64bit processors if memeory and > everything else is the same? As for the raw CPU power, I have no figures. You probably know that a Power CPU gets more performance per MHz than an x86 one. In the DB context, you can typically use integer benchmarks as a rough guideline AFAIK. IMNSHO, you buy a 64 bit CPU in order to have (now or later) more RAM to fill your large address space, and in the DBMS context you will be using this RAM for caches. Then, the question is: "What kind of performance difference can I expect from larger caches?" And to this, the typical answer is: "It depends on the amount of data accessed frequently enough. As soon as you can reuse data in the cache, you save the disk access cost." So IMO using a 64 bit CPU ensures you can use larger caches either immediately or later, it protects your basic hardware (+ software + admin training) investments in case your data (are or get) too large. Still IMO, this also means you always should select a box that allows for RAM upgrade, even if you do not buy it immediately (unless you know it will not grow that much). In short: "There is only one replacfement for RAM: more RAM!" Regards and HTH, Joerg -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
