54 lines
4.6 KiB
XML
54 lines
4.6 KiB
XML
<?xml version="1.0" encoding="UTF-8"?>
|
|
<mxfile host="app.diagrams.net" modified="2026-07-23T00:00:00.000Z" agent="techviz-harness" version="24.7.17" type="device">
|
|
<diagram id="batch-fetch-in-clause" name="배치는 부모를 먼저 페이징하고 자식을 IN으로 따로 가져온다">
|
|
<mxGraphModel dx="870" dy="542" grid="1" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="1" pageScale="1" pageWidth="870" pageHeight="1169" math="0" shadow="0">
|
|
<root>
|
|
<mxCell id="0"/>
|
|
<mxCell id="1" parent="0"/>
|
|
<mxCell id="n_loader" value="조회 코드" tooltip="페이지를 요청하는 애플리케이션 코드 | Evidence: L1009-L1010" style="whiteSpace=wrap;html=1;rounded=1;strokeWidth=2;fontSize=14;fontStyle=1;fillColor=#ffffff;strokeColor=#2d4357;verticalAlign=middle;dashed=1;fillColor=#f5f7fa;" vertex="1" parent="1">
|
|
<mxGeometry x="45.0" y="35.0" width="150.0" height="78.0" as="geometry"/>
|
|
</mxCell>
|
|
<mxCell id="n_session" value="Hibernate 세션" tooltip="default_batch_fetch_size로 프록시를 모으는 주체 | Evidence: L1010-L1012" style="whiteSpace=wrap;html=1;rounded=1;strokeWidth=2;fontSize=14;fontStyle=1;fillColor=#ffffff;strokeColor=#2d4357;verticalAlign=middle;" vertex="1" parent="1">
|
|
<mxGeometry x="255.0" y="35.0" width="150.0" height="64.0" as="geometry"/>
|
|
</mxCell>
|
|
<mxCell id="n_feed-items" value="feed_items" tooltip="부모 테이블 | Evidence: L1009-L1010" style="whiteSpace=wrap;html=1;rounded=1;strokeWidth=2;fontSize=14;fontStyle=1;fillColor=#ffffff;strokeColor=#2d4357;verticalAlign=middle;shape=cylinder3;boundedLbl=1;backgroundOutline=1;fillColor=#eef6fb;" vertex="1" parent="1">
|
|
<mxGeometry x="465.0" y="35.0" width="150.0" height="78.0" as="geometry"/>
|
|
</mxCell>
|
|
<mxCell id="n_highlights" value="highlights" tooltip="자식 테이블 | Evidence: L1010-L1011" style="whiteSpace=wrap;html=1;rounded=1;strokeWidth=2;fontSize=14;fontStyle=1;fillColor=#ffffff;strokeColor=#2d4357;verticalAlign=middle;shape=cylinder3;boundedLbl=1;backgroundOutline=1;fillColor=#eef6fb;" vertex="1" parent="1">
|
|
<mxGeometry x="675.0" y="35.0" width="150.0" height="78.0" as="geometry"/>
|
|
</mxCell>
|
|
<mxCell id="e_m1" value="부모 페이지 요청" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;strokeWidth=2;endArrow=block;endFill=1;" edge="1" parent="1" source="n_loader" target="n_session">
|
|
<mxGeometry relative="1" as="geometry">
|
|
<mxPoint x="225.0" y="128.0" as="offset"/>
|
|
</mxGeometry>
|
|
</mxCell>
|
|
<mxCell id="e_m2" value="부모 LIMIT 페이징" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;strokeWidth=2;endArrow=block;endFill=1;" edge="1" parent="1" source="n_session" target="n_feed-items">
|
|
<mxGeometry relative="1" as="geometry">
|
|
<mxPoint x="435.0" y="190.0" as="offset"/>
|
|
</mxGeometry>
|
|
</mxCell>
|
|
<mxCell id="e_m3" value="페이지 부모 + 미초기화 프록시" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;strokeWidth=2;endArrow=block;endFill=1;" edge="1" parent="1" source="n_feed-items" target="n_session">
|
|
<mxGeometry relative="1" as="geometry">
|
|
<mxPoint x="435.0" y="252.0" as="offset"/>
|
|
</mxGeometry>
|
|
</mxCell>
|
|
<mxCell id="e_m4" value="WHERE fk IN (?,…) 배치" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;strokeWidth=2;endArrow=block;endFill=1;" edge="1" parent="1" source="n_session" target="n_highlights">
|
|
<mxGeometry relative="1" as="geometry">
|
|
<mxPoint x="540.0" y="314.0" as="offset"/>
|
|
</mxGeometry>
|
|
</mxCell>
|
|
<mxCell id="e_m5" value="자식 행" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;strokeWidth=2;endArrow=block;endFill=1;" edge="1" parent="1" source="n_highlights" target="n_session">
|
|
<mxGeometry relative="1" as="geometry">
|
|
<mxPoint x="540.0" y="376.0" as="offset"/>
|
|
</mxGeometry>
|
|
</mxCell>
|
|
<mxCell id="e_m6" value="부모 + 컬렉션" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;strokeWidth=2;endArrow=block;endFill=1;" edge="1" parent="1" source="n_session" target="n_loader">
|
|
<mxGeometry relative="1" as="geometry">
|
|
<mxPoint x="225.0" y="438.0" as="offset"/>
|
|
</mxGeometry>
|
|
</mxCell>
|
|
</root>
|
|
</mxGraphModel>
|
|
</diagram>
|
|
</mxfile>
|