mirror of
https://github.com/vladtrc/iw4L
synced 2026-10-26 02:11:39 -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>
47 lines
909 B
SQL
47 lines
909 B
SQL
-- Keep-set envelopes and hot leaves (P4 / I12). Missing names are absent
|
|
-- from this recording, not a SQL error — the runner flags them.
|
|
SELECT
|
|
name,
|
|
COUNT(*) AS n,
|
|
CAST(AVG(dur) / 1e6 AS REAL) AS avg_ms,
|
|
CAST(MAX(dur) / 1e6 AS REAL) AS max_ms,
|
|
CAST(SUM(dur) / 1e6 AS REAL) AS sum_ms
|
|
FROM slice
|
|
WHERE name IN (
|
|
'wall',
|
|
'FixedUpdate',
|
|
'Update',
|
|
'PreUpdate',
|
|
'PostUpdate',
|
|
'Present',
|
|
'Predict',
|
|
'Effects',
|
|
'Diag',
|
|
'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',
|
|
'fx_update',
|
|
'fx_present',
|
|
'cull',
|
|
'Load',
|
|
'Receive',
|
|
'Reconcile',
|
|
'Input',
|
|
'Send',
|
|
'Ui',
|
|
'Advance',
|
|
'Ingress',
|
|
'Gather',
|
|
'Step',
|
|
'Snapshot',
|
|
'Fanout',
|
|
'Bookkeeping'
|
|
)
|
|
GROUP BY name
|
|
ORDER BY sum_ms DESC;
|