Welcome to MemOC.org
Welcome to MemOC.org - a site devoted to memory overclocking.
This is just a test site for the real one, so feel free to give any comments, suggestions or ideas in the forums. Currently everything you see here (including this text, of course) is a subject to change, not a final shape.
Best overclockers
1. 620 - phobos in CPU-Z at 620 MHz - 16.32 % overclock
2. 257.8 - phobos in CPU-Z at 257.8 MHz - -6.25 % overclock
3. 257.8 - phobos in CPU-Z at 257.8 MHz - -6.25 % overclock
4. 257.8 - phobos in CPU-Z at 257.8 MHz - -6.25 % overclock
5. 257.8 - phobos in CPU-Z at 257.8 MHz - -6.25 % overclock
Statistics
7Queries:
Time needed:
select mn.posting_date, mn.news_id, mn.short_text, mn.user_id, mu.user_login from memoc_news mn inner join memoc_users mu on mn.user_id = mu.id order by posting_date desc limit 5
select ms.id, ms.speed, mu.user_login, ms.user_id from memoc_scores ms inner join memoc_users mu on ms.user_id = mu.id order by speed desc limit 5
select ms.id, ms.speed, ms.result, ma.name, mu.user_login, ms.user_id from memoc_scores ms inner join memoc_users mu on ms.user_id = mu.id inner join memoc_application ma on ms.application_id = ma.id order by ms.posting_date desc limit 5
SELECT ms.id, ms.sticks_id, ma.name, ms.user_id, mu.user_login, ms.speed, mss.speed AS orig_speed, 100 * ( ms.speed - mss.speed ) / mss.speed AS percent
FROM memoc_scores ms
INNER JOIN memoc_sticks mss ON ms.sticks_id = mss.id
INNER JOIN memoc_application ma ON ms.application_id = ma.id
INNER JOIN memoc_users mu ON ms.user_id = mu.id
ORDER BY (ms.speed - mss.speed) / mss.speed DESC
LIMIT 5
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