Result #3 overview
Crucial Ballistix 1066
1st position in
CPU-Z for
DDR2 1066
Dual channel
DDR2 memory.
Stick capacity of
1024 MB, running at the speed of
620 MHz.
Timings:
5-
5-
5-
15 (tCL-tRP-tRCD-tRAS).
Motherboard used:
DFI LP NF4 Series, chipset:
NVIDIA nForce4 rev A3.
CPU settings:
AMD Athlon 64 X2 3800+, running at
2900.12 MHz.
FSB/HTT:
290.01Multiplier:
10
Validation: link
Statistics
4Queries:
Time needed:
SELECT ms.* , mu.* , mcs.* , mss.*, md1.value AS
mem_type , md2.value AS channels, ma.name as app_name, mss.speed as orig_speed, mcs.speed as cpu_speed, md3.value as cpu_producer, md4.value as cpu_model, md5.value as cpu_name, md6.value as mobo_maker, md7.value as mobo_model, md8.value as chipset_id,
md9.value as stick_producer, md10.value as stick_model
FROM memoc_scores ms
INNER JOIN memoc_users mu ON ms.user_id = mu.id
INNER JOIN memoc_cpu_score mcs ON ms.cpu_score_id = mcs.id
inner join memoc_mobo mm on mcs.mobo_id = mm.id
inner join memoc_cpu mc on mcs.cpu_id = mc.id
INNER JOIN memoc_application ma on ms.application_id = ma.id
INNER JOIN memoc_sticks mss on ms.sticks_id = mss.id
INNER JOIN memoc_dictionary md1 ON ms.memory_type = md1.id
INNER JOIN memoc_dictionary md2 ON ms.channels = md2.id
INNER JOIN memoc_dictionary md3 ON mc.producer_id = md3.id
INNER JOIN memoc_dictionary md4 ON mc.model = md4.id
INNER JOIN memoc_dictionary md5 ON mc.name = md5.id
INNER JOIN memoc_dictionary md6 ON mm.producer_id = md6.id
INNER JOIN memoc_dictionary md7 ON mm.model = md7.id
INNER JOIN memoc_dictionary md8 ON mm.chipset_id = md8.id
INNER JOIN memoc_dictionary md9 ON mss.brand_id = md9.id
inner join memoc_dictionary md10 on mss.model_id = md10.id
WHERE ms.id = 3;
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