Mini-CaCtuS

回覆 20# Advanced Ivan


    咁我諗我要試清楚先好買... 好在我係買2手,有得帶對RAM去試左先

我見有粒5960X@4.5G行1.2v想收

Advanced Ivan

回覆  Advanced Ivan


    咁我諗我要試清楚先好買... 好在我係買2手,有得帶對RAM去試左先

我見有粒行1. ...
Mini-CaCtuS 發表於 2016-4-28 10:09

玩高頻, 就揀Skylake啦......
X99係比你玩8核同Quad Channel, 高頻不是他的強項, 唔好勉強, 唸清楚想要D咩先

Mini-CaCtuS

回覆 22# Advanced Ivan


    我其實已經有套6600K@4.5G行1.25v (x45 Cache),亦都係插住4條G.Skill 3200mhz C14 16GB Sticks
btw,我留意到原來我d 16GB Sticks可能係Dual channel黎,只係有兩pack,對包裝印象模糊sorry

諗住一係加台x99行8核,甚至換走台z170,原意係俾我做vlookup果陣可以行快d,但之後發現其實可能仲可以靠xeon,但又唔想浪費左對RAM,所以先出PO問XMP問題

Mini-CaCtuS

本黎我係公司用I5 notebook行excel vlookup覺得好慢,所以先會remote返去開隻vm  sandbox黎做,雖然隻vm係裝係套z170 I5到,但發現資料太多都係太慢,某日咁岩借到朋友台5960x黎試行,4.5Ghz 16線程真係快好多,所以開始心郁去研究,後期見到broadwell ep出,仲諗埋xeon會唔會更加快~

Advanced Ivan

回覆  Advanced Ivan


    我其實已經有套行1.25v (x45 Cache),亦都係插住4條G.Skill 3200mhz C14 16GB S ...
Mini-CaCtuS 發表於 2016-4-28 10:54

試下轉用Index-Match代替vlookup, 某D情況會快D
http://www.exceluser.com/formula ... er-than-vlookup.htm

Mini-CaCtuS

回覆 25# Advanced Ivan


    好,等我研究下! Thanks ching!

Mini-CaCtuS

本身諗住睇下塊ASUS X99-M WS的Memory Qualified Vendor List,見到都有差唔多所有mhz的range,姐係由2133-3200mhz都有,但之後留意到remarks有句野寫住:

-Memory module with memory frequency higher than 2133 MHz and its corresponding timing or the loaded XMP Profile is not the JEDEC memory standard. The stability and compatibility of these memory modules depend on the CPU’s capabilities and other installed devices.

咁咪姐係插3200落去但CPU(的IMC)唔夠力都照打返你落去2133?