mirror of
https://github.com/vladtrc/iw4L
synced 2026-10-26 10:19:50 -04:00
vtroc7
94e3983bfc
- One common set per content profile, shared by every match and the loadout menu; a restart over the same map keeps its images and static geometry. - Weapons resolve as families: attachments are chosen from each game's own tables, checked, and composed into prepared configurations with their first-person skeleton assembled once. - Sessions end through one teardown and one process exit; retired resources are dropped on a worker, not the frame. - Sound is captured by the walks that already read each zone. - A loading screen that reports what the load is doing. - Tests live only in crates/approved_tests (heavy_gameplay_lifecycle); publish-check refuses them anywhere else. Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
44 lines
1.3 KiB
SQL
44 lines
1.3 KiB
SQL
-- Render topic pack: existing producer durations and counters, active gameplay only.
|
|
WITH active AS (
|
|
SELECT COALESCE(MIN(ts), (SELECT MIN(ts) FROM slice)) AS start
|
|
FROM slice
|
|
WHERE name = 'player_tick'
|
|
),
|
|
render_spans AS (
|
|
SELECT
|
|
'span' AS kind,
|
|
name,
|
|
COUNT(*) AS n,
|
|
ROUND(AVG(dur) / 1000000.0, 3) AS avg_value,
|
|
ROUND(MAX(dur) / 1000000.0, 3) AS max_value,
|
|
'ms' AS unit
|
|
FROM slice, active
|
|
WHERE ts >= active.start
|
|
AND dur >= 0
|
|
AND name IN (
|
|
'wall', 'PostUpdate', 'Present', 'extract_wait', 'receive_render_world', 'extract_body', 'dispatch_render_world',
|
|
'static_sun_fx', 'static_sun', 'render_thread',
|
|
'render_render', 'post_execute', 'post_rebuild', 'colour_submit',
|
|
'skin_model', 'cull'
|
|
)
|
|
GROUP BY name
|
|
),
|
|
render_counters AS (
|
|
SELECT
|
|
'counter' AS kind,
|
|
ct.name,
|
|
COUNT(*) AS n,
|
|
ROUND(AVG(c.value), 3) AS avg_value,
|
|
ROUND(MAX(c.value), 3) AS max_value,
|
|
CASE WHEN ct.name = 'gpu_frame' THEN 'ms' ELSE 'count' END AS unit
|
|
FROM counter c
|
|
JOIN counter_track ct ON c.track_id = ct.id, active
|
|
WHERE c.ts >= active.start
|
|
AND ct.name IN ('draws', 'batches', 'gpu_frame')
|
|
GROUP BY ct.name
|
|
)
|
|
SELECT * FROM render_spans
|
|
UNION ALL
|
|
SELECT * FROM render_counters
|
|
ORDER BY kind DESC, name;
|