Go Back   HWBOT forum > > >

Skylake/Kaby Lake/Coffee Lake (-X) (Z170/Z270/Z370/X299) OC The sky is the limit


User Tag List

Reply
 
Thread Tools Display Modes
  #1  
Old 01-12-2017
Massman's Avatar
Massman Massman is offline
In the distance
 
Join Date: Jul 2006
Location: Taipei
Posts: 22,506
Thanks: 775
Thanked 1,055 Times in 526 Posts
Massman has a spectacular aura aboutMassman has a spectacular aura aboutMassman has a spectacular aura about
Send a message via MSN to Massman
Default Kaby Lake / Z270 Overclocking Statistics

Kaby Lake Statistics
  • 964 overclocking results
  • 132 overclockers
Hardware Statistics
Top-5 Motherboard Brands ASUS, GIGABYTE, MSI
Top-5 Mainboards (users) GIGABYTE Z270X-Gaming SOC, ASUS ROG Maximus IX Formula, ASUS ROG Maximus IX Hero, MSI Z270 XPower Gaming Titanium, ASUS ROG Maximus IX Apex
Top-5 Mainboards (submissions) GIGABYTE Z270X-Gaming SOC, ASUS ROG Maximus IX Apex, ASUS ROG Maximus IX Formula, MSI Z270 XPower Gaming Titanium, ASUS ROG Maximus IX Hero
Top-5 Memory Brand (users) G.SKILL, Corsair, Samsung, Kingston, GALAX
Top-5 CPU SKU Core i7 7700K, Core i7 7500U, Core i5 7600K, Core i5 7200U, Core i3 7350K
Top-5 CPU Cooling Liquid Nitrogen (50.65%), AIO Water (15.45%), Water cooling (10.94%), Air cooling (6.91%), Cascade (3.17%)

Last updated: 15/11/2016

Community Statistics
Most Active User topyoyoguybest, 41 submissions
Most Active Team PURE, 51 submissions
Most Active Country United States, 241 submissions
Highest Variety CPUs by User 7 users, 2 CPUs
Highest Variety CPUs by Team Overclockers.com, 3 CPUs
Highest Variety CPUs by Country 4 countries, 40 CPUs
Highest Variety Motherboards by User Bboyjezz, 3 motherboards
Highest Variety Motherboards by Team Hardwareluxx.de, 5 motherboards
Highest Variety Motherboards by Country Germany, 14 motherboards

Code:
SELECT COUNT(*), COUNT(DISTINCT user_id), COUNT(DISTINCT result.mb_model_id) FROM result JOIN cpu_model USING (cpu_id) WHERE core_id=1219;
SELECT COUNT(*), COUNT(DISTINCT mb_model.manufacturer_id) FROM mb_model WHERE mb_model.chipset_id=6391;

SELECT manufacturer.name, COUNT(*) FROM result JOIN mb_model ON (result.mb_model_id = mb_model.model_id) JOIN manufacturer USING (manufacturer_id) WHERE (mb_model.chipset_id = 6391) GROUP BY manufacturer_id ORDER BY COUNT(*) DESC;
SELECT mb_model.name, COUNT(DISTINCT user_id) FROM result JOIN mb_model ON (result.mb_model_id = mb_model.model_id) JOIN manufacturer USING (manufacturer_id) WHERE (mb_model.chipset_id = 6391) GROUP BY mb_model.model_id ORDER BY COUNT(DISTINCT user_id) DESC;
SELECT mb_model.name, COUNT(*) FROM result JOIN mb_model ON (result.mb_model_id = mb_model.model_id) JOIN manufacturer USING (manufacturer_id) WHERE (mb_model.chipset_id = 6391) GROUP BY mb_model.model_id ORDER BY COUNT(*) DESC;
SELECT mb_model.name, COUNT(DISTINCT user_id) FROM result JOIN mb_model ON (result.mb_model_id = mb_model.model_id) JOIN manufacturer USING (manufacturer_id) WHERE (mb_model.chipset_id=6391 AND result.cpucooling_id=9) GROUP BY mb_model.model_id ORDER BY COUNT(DISTINCT user_id) DESC;

SELECT result_data.memory_vendor, COUNT(*) FROM result JOIN result_data USING (data_id) JOIN cpu_model USING (cpu_id) WHERE core_id=1219 GROUP BY memory_vendor ORDER BY COUNT(*) DESC;
SELECT cpu_model.model, COUNT(*) FROM result JOIN cpu_model USING (cpu_id) WHERE core_id=1219 GROUP BY cpu_id ORDER BY COUNT(*) DESC;

SELECT cooling.name, COUNT(*)/1321 FROM result JOIN cooling ON (result.cpucooling_id = cooling.cooling_id) JOIN cpu_model USING (cpu_id) WHERE core_id=1219 GROUP BY cooling.cooling_id ORDER BY COUNT(*) DESC;

SELECT user.name, COUNT(*) FROM result JOIN USER USING (user_id) JOIN cpu_model USING (cpu_id) WHERE cpu_model.core_id=1219 GROUP BY user_id ORDER BY COUNT(*) DESC;
SELECT team.teamname, COUNT(*) FROM result JOIN USER USING (user_id) JOIN team ON (user.team_id = team.team_id) JOIN cpu_model USING (cpu_id) WHERE cpu_model.core_id=1219 GROUP BY team.team_id ORDER BY COUNT(*) DESC;
SELECT country.name, COUNT(*) FROM result JOIN USER USING (user_id) JOIN country USING (country_id) JOIN cpu_model USING (cpu_id) WHERE cpu_model.core_id=1219 GROUP BY country_id ORDER BY COUNT(*) DESC;
SELECT user.name, COUNT(DISTINCT cpu_id) FROM result JOIN USER USING (user_id) JOIN cpu_model USING (cpu_id) WHERE cpu_model.core_id=1219 GROUP BY user_id ORDER BY COUNT(DISTINCT cpu_id) DESC;
SELECT team.teamname, COUNT(DISTINCT cpu_id) FROM result JOIN USER USING (user_id) JOIN team ON (user.team_id = team.team_id) JOIN cpu_model USING (cpu_id) WHERE cpu_model.core_id=1219 GROUP BY team.team_id ORDER BY COUNT(DISTINCT cpu_id) DESC;
SELECT country.name, COUNT(DISTINCT cpu_id) FROM result JOIN USER USING (user_id) JOIN country USING (country_id) JOIN cpu_model USING (cpu_id) WHERE cpu_model.core_id=1219 GROUP BY country_id ORDER BY COUNT(DISTINCT cpu_id) DESC;
SELECT user.name, COUNT(DISTINCT result.mb_model_id) FROM result JOIN USER USING (user_id) JOIN cpu_model USING (cpu_id) WHERE cpu_model.core_id=1219 GROUP BY user_id ORDER BY COUNT(DISTINCT result.mb_model_id) DESC;
SELECT team.teamname, COUNT(DISTINCT result.mb_model_id) FROM result JOIN USER USING (user_id) JOIN team ON (user.team_id = team.team_id) JOIN cpu_model USING (cpu_id) WHERE cpu_model.core_id=1219 GROUP BY team.team_id ORDER BY COUNT(DISTINCT result.mb_model_id) DESC;
SELECT country.name, COUNT(DISTINCT result.mb_model_id) FROM result JOIN USER USING (user_id) JOIN country USING (country_id) JOIN cpu_model USING (cpu_id) WHERE cpu_model.core_id=1219 GROUP BY country_id ORDER BY COUNT(DISTINCT result.mb_model_id) DESC;
__________________
Where courage, motivation and ignorance meet, a persistent idiot awakens.

For all HWBOT community related questions, contact Christian Ney or Websmile. For any other questions, contact me at pieter@hwbot.org.
Reply With Quote
The Following 7 Users Say Thank You to Massman For This Useful Post:
Bruno (01-14-2017), flanker (01-16-2017), M.Beier (01-12-2017), MetalRacer (01-12-2017), Strong Island (01-12-2017), topyoyoguybest (01-27-2017), TyphooNick (03-20-2017)
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[Rehwolution] ASRock Fatal1ty Z270 Gaming K6 e Kaby Lake i5 7600k hwbotrss Tech News RSS 0 01-10-2017 23:50
[AT] G.Skill Announces Trident Z DDR4 DIMMs for Kaby Lake CPUs hwbotrss Tech News RSS 0 01-04-2017 18:00
[AT] Intel Launches 7th Generation Kaby Lake: 15W/28W with Iris, 35-91W Desktop and Mobile Xeon hwbotrss Tech News RSS 0 01-03-2017 18:40
[AT] Kaby Lake Systems With Intel Optane SSDs Coming Soon hwbotrss Tech News RSS 0 12-28-2016 06:11
[AT] Dell Readies New XPS 15: 4K, Quad-Core Kaby Lake, GeForce GTX 1050 hwbotrss Tech News RSS 0 12-23-2016 22:11


All times are GMT +1. The time now is 07:05.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2017 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging (Lite) - vBulletin Mods & Addons Copyright © 2017 DragonByte Technologies Ltd.
Copyright HWBOT 2004 - 2015