phobos's profile:

1. 620 Mhz in CPU-Z - 1st in DDR2 1066 with Crucial Ballistix 1066

2. 257.8 Mhz in CPU-Z - 9th in DDR 550 with G.Skill F1-4400DSU2-1GBLE

3. 257.8 Mhz in CPU-Z - 1st in DDR 600 with G.Skill F1-4800DSU2-1GBLA

4. 257.8 Mhz in CPU-Z - 5th in DDR 550 with G.Skill F1-4400DSU2-1GBLE

5. 257.8 Mhz in CPU-Z - 7th in DDR 600 with G.Skill F1-4800DSU2-1GBLA

6. 257.8 Mhz in CPU-Z - 2nd in DDR 550 with G.Skill F1-4400DSU2-1GBLE

7. 257.8 Mhz in CPU-Z - 3rd in DDR 600 with G.Skill F1-4800DSU2-1GBLA

8. 257.8 Mhz in CPU-Z - 8th in DDR 550 with G.Skill F1-4400DSU2-1GBLE

9. 257.8 Mhz in CPU-Z - 0th in DDR 600 with G.Skill F1-4800DSU2-1GBLA

10. 257.8 Mhz in CPU-Z - 4th in DDR 550 with G.Skill F1-4400DSU2-1GBLE

11. 257.8 Mhz in CPU-Z - 6th in DDR 600 with G.Skill F1-4800DSU2-1GBLA

12. 257.8 Mhz in CPU-Z - 1st in DDR 550 with G.Skill F1-4400DSU2-1GBLE

13. 257.8 Mhz in CPU-Z - 0th in DDR 550 with G.Skill F1-4400DSU2-1GBLD

14. 257.8 Mhz in CPU-Z - 2nd in DDR 600 with G.Skill F1-4800DSU2-1GBLA

15. 257.8 Mhz in CPU-Z - 6th in DDR 550 with G.Skill F1-4400DSU2-1GBLE

16. 257.8 Mhz in CPU-Z - 0th in DDR 600 with G.Skill F1-4800DSU2-1GBLA

17. 257.8 Mhz in CPU-Z - 0th in DDR 600 with G.Skill F1-4800DSU2-1GBFX

18. 257.8 Mhz in CPU-Z - 3rd in DDR 550 with G.Skill F1-4400DSU2-1GBLE

19. 257.8 Mhz in CPU-Z - 4th in DDR 600 with G.Skill F1-4800DSU2-1GBLA

20. 254.2 Mhz in CPU-Z - 8th in DDR 600 with G.Skill F1-4800DSU2-1GBLA

21. 254.2 Mhz in CPU-Z - 0th in DDR 600 with G.Skill F1-4800DSU2-1GBFX

22. 254.2 Mhz in CPU-Z - 9th in DDR 600 with G.Skill F1-4800DSU2-1GBLA

23. 245.1 Mhz in CPU-Z - 10th in DDR 600 with G.Skill F1-4800DSU2-1GBLA

24. 245.1 Mhz in CPU-Z - 0th in DDR 600 with G.Skill F1-4800DSU2-1GBFF

25. 245.1 Mhz in CPU-Z - 0th in DDR 600 with G.Skill F1-4800DSU2-1GBFR

26. 242 Mhz in CPU-Z - 10th in DDR 550 with G.Skill F1-4400DSU2-1GBLE

27. 242 Mhz in CPU-Z - 11th in DDR 600 with G.Skill F1-4800DSU2-1GBLA

28. 241.7 Mhz in CPU-Z - 0th in DDR 550 with G.Skill F1-4400DSU2-1GBLD

29. 241.7 Mhz in CPU-Z - 1st in DDR 600 with G.Skill F1-4800DSU2-1GBFX

30. 211.5 Mhz in CPU-Z - 3rd in DDR 600 with G.Skill F1-4800DSU2-1GBFX

31. 211.5 Mhz in CPU-Z - 4th in DDR 600 with G.Skill F1-4800DSU2-1GBFX

32. 211.5 Mhz in CPU-Z - 2nd in DDR 600 with G.Skill F1-4800DSU2-1GBFX

Main
Home
Rules
FAQ
Download
About
World records
DDR
phobos - 257.8 MHz

DDR2
phobos - 620 MHz

Top overclockers
Most scores:
1. phobos32

Most records:
1. phobos4

Info
Statistics
5Queries:
Time needed:

select ms.*, s.speed as orig_speed, ma.name as app_name, dd1.value as brand_name, dd2.value as model_name, dd3.value as memory_typename from memoc_scores ms INNER JOIN memoc_sticks s ON ms.sticks_id = s.id INNER JOIN memoc_dictionary dd1 ON s.brand_id = dd1.id INNER JOIN memoc_dictionary dd2 ON s.model_id = dd2.id inner join memoc_dictionary dd3 on ms.memory_type = dd3.id inner join memoc_application ma on ms.application_id = ma.id where ms.user_id = 1 and ms.approved = 1 order by ms.speed desc;

select * from memoc_users where id = 1;

SELECT d1.id, d1.value as mem_type, ms.id, ms.speed, ms.memory_type, dd1.value AS brand_name, dd2.value AS model_name, u.id AS user_id, u.user_login FROM memoc_dictionary d1 INNER JOIN memoc_scores ms ON d1.id = ms.memory_type AND ms.speed = ( SELECT max( ms.speed ) FROM memoc_scores ms2 WHERE ms2.memory_type = ms.memory_type ORDER BY ms2.posting_date DESC ) AND ms.id = ( SELECT ms3.id FROM memoc_scores ms3 WHERE ms3.memory_type = ms.memory_type ORDER BY ms3.speed DESC , ms3.posting_date DESC LIMIT 1 ) INNER JOIN memoc_sticks s ON ms.sticks_id = s.id INNER JOIN memoc_dictionary dd1 ON s.brand_id = dd1.id INNER JOIN memoc_dictionary dd2 ON s.model_id = dd2.id INNER JOIN memoc_users u ON ms.user_id = u.id WHERE d1.dict_group = 'mem_type' ORDER BY d1.value ASC ;

select id, user_login, max(score_count) as score_count from (select u.id, u.user_login, count(s.id) as score_count from memoc_scores s inner join memoc_users u on s.user_id = u.id where s.approved = 1 group by u.id, u.user_login) as us group by id, user_login limit 0, 4

SELECT s.user_id, u.user_login, count( s.id ) AS score_count FROM memoc_scores s INNER JOIN memoc_users u ON s.user_id = u.id WHERE s.position = 1 and s.approved = 1 GROUP BY s.user_id LIMIT 0, 5