프로젝트

일반

사용자정보

개정판 d7e20d2d

IDd7e20d2dad8780ab6ede36daf8f904e52efd6f80
상위 b4b23404
하위 dea506e2

김태성이(가) 약 5년 전에 추가함

markus 성능개선
- 일정 페이지범위를 local 저장소에 저장

Change-Id: Ib6ef3d770a360c40acf01d6de04668bee653eee4

차이점 보기:

DataBase/EntityModel/MarkusModel.edmx
4 4 
  <edmx:Runtime>
5 5 
    <!-- SSDL content -->
6 6 
    <edmx:StorageModels>
7 
      <Schema Namespace="MarkusDBModel.Store" Provider="System.Data.SqlClient" ProviderManifestToken="2012" Alias="Self" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
7 
    <Schema Namespace="MarkusDBModel.Store" Provider="System.Data.SqlClient" ProviderManifestToken="2012" Alias="Self" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
8 8 
        <EntityType Name="ATTACH_URL">
9 9 
          <Key>
10 10 
            <PropertyRef Name="ID" />
......
119 119 
          </Key>
120 120 
          <Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" />
121 121 
          <Property Name="PROJECT_NO" Type="nvarchar" MaxLength="10" Nullable="false" />
122 
          <Property Name="DOCINFO_ID" Type="int" Nullable="false" />
122 
          <Property Name="DOCINFO_ID" Type="nvarchar" MaxLength="50" Nullable="false" />
123 123 
          <Property Name="MARKUPINFO_ID" Type="int" Nullable="false" />
124 124 
          <Property Name="CREATE_USER_ID" Type="nvarchar" MaxLength="50" Nullable="false" />
125 125 
          <Property Name="CREATE_DATETIME" Type="datetime" Nullable="false" />
......
462 462 
            <End Role="SYMBOL_PRIVATE" EntitySet="SYMBOL_PRIVATE" />
463 463 
          </AssociationSet>
464 464 
        </EntityContainer>
465 
      </Schema>
466 
    </edmx:StorageModels>
465 
      </Schema></edmx:StorageModels>
467 466 
    <!-- CSDL content -->
468 467 
    <edmx:ConceptualModels>
469 468 
      <Schema Namespace="MarkusDBModel" Alias="Self" annotation:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
......
581 580 
          <Property Name="PAGE_NO" Type="Int32" Nullable="false" />
582 581 
          <NavigationProperty Name="MEMBER" Relationship="Self.FK_FAVORIT_DOC_FAVORIT_DOC" FromRole="FAVORITE_DOC" ToRole="MEMBER" />
583 582 
        </EntityType>
584 
        <EntityType Name="FINAL_PDF">
585 
          <Key>
586 
            <PropertyRef Name="ID" />
587 
          </Key>
588 
          <Property Name="ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
589 
          <Property Name="PROJECT_NO" Type="String" MaxLength="10" FixedLength="false" Unicode="true" Nullable="false" />
590 
          <Property Name="DOCINFO_ID" Type="Int32" Nullable="false" />
591 
          <Property Name="MARKUPINFO_ID" Type="Int32" Nullable="false" />
592 
          <Property Name="CREATE_USER_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
593 
          <Property Name="CREATE_DATETIME" Type="DateTime" Nullable="false" Precision="3" />
594 
          <Property Name="STATUS" Type="Int32" Nullable="false" />
595 
          <Property Name="TOTAL_PAGE" Type="Int32" Nullable="false" />
596 
          <Property Name="CURRENT_PAGE" Type="Int32" Nullable="false" />
597 
          <Property Name="EXCEPTION" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
598 
          <Property Name="END_DATETIME" Type="DateTime" Precision="3" />
599 
          <Property Name="START_DATETIME" Type="DateTime" Precision="3" />
600 
          <Property Name="DOCUMENT_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
601 
        </EntityType>
602 583 
        <EntityType Name="LOGIN_STAMP">
603 584 
          <Key>
604 585 
            <PropertyRef Name="ID" />
......
890 871 
          <EntitySet Name="DOCUMENT_ITEM" EntityType="Self.DOCUMENT_ITEM" />
891 872 
          <EntitySet Name="ERROR_LOG" EntityType="Self.ERROR_LOG" />
892 873 
          <EntitySet Name="FAVORITE_DOC" EntityType="Self.FAVORITE_DOC" />
893 
          <EntitySet Name="FINAL_PDF" EntityType="Self.FINAL_PDF" />
894 874 
          <EntitySet Name="LOGIN_STAMP" EntityType="Self.LOGIN_STAMP" />
895 875 
          <EntitySet Name="MARKUP_CHECKLIST" EntityType="Self.MARKUP_CHECKLIST" />
896 876 
          <EntitySet Name="MARKUP_DATA" EntityType="Self.MARKUP_DATA" />
......
939 919 
            <End Role="MEMBER" EntitySet="MEMBER" />
940 920 
            <End Role="SYMBOL_PRIVATE" EntitySet="SYMBOL_PRIVATE" />
941 921 
          </AssociationSet>
922 
          <EntitySet Name="FINAL_PDF" EntityType="MarkusDBModel.FINAL_PDF" />
942 923 
        </EntityContainer>
924 
        <EntityType Name="FINAL_PDF">
925 
          <Key>
926 
            <PropertyRef Name="ID" />
927 
          </Key>
928 
          <Property Name="ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
929 
          <Property Name="PROJECT_NO" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" />
930 
          <Property Name="DOCINFO_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
931 
          <Property Name="MARKUPINFO_ID" Type="Int32" Nullable="false" />
932 
          <Property Name="CREATE_USER_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
933 
          <Property Name="CREATE_DATETIME" Type="DateTime" Nullable="false" Precision="3" />
934 
          <Property Name="STATUS" Type="Int32" Nullable="false" />
935 
          <Property Name="TOTAL_PAGE" Type="Int32" Nullable="false" />
936 
          <Property Name="CURRENT_PAGE" Type="Int32" Nullable="false" />
937 
          <Property Name="EXCEPTION" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
938 
          <Property Name="END_DATETIME" Type="DateTime" Precision="3" />
939 
          <Property Name="START_DATETIME" Type="DateTime" Precision="3" />
940 
          <Property Name="DOCUMENT_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
941 
        </EntityType>
943 942 
      </Schema>
944 943 
    </edmx:ConceptualModels>
945 944 
    <!-- C-S mapping content -->
......
1062 1061 
              </MappingFragment>
1063 1062 
            </EntityTypeMapping>
1064 1063 
          </EntitySetMapping>
1065 
          <EntitySetMapping Name="FINAL_PDF">
1066 
            <EntityTypeMapping TypeName="MarkusDBModel.FINAL_PDF">
1067 
              <MappingFragment StoreEntitySet="FINAL_PDF">
1068 
                <ScalarProperty Name="ID" ColumnName="ID" />
1069 
                <ScalarProperty Name="PROJECT_NO" ColumnName="PROJECT_NO" />
1070 
                <ScalarProperty Name="DOCINFO_ID" ColumnName="DOCINFO_ID" />
1071 
                <ScalarProperty Name="MARKUPINFO_ID" ColumnName="MARKUPINFO_ID" />
1072 
                <ScalarProperty Name="CREATE_USER_ID" ColumnName="CREATE_USER_ID" />
1073 
                <ScalarProperty Name="CREATE_DATETIME" ColumnName="CREATE_DATETIME" />
1074 
                <ScalarProperty Name="STATUS" ColumnName="STATUS" />
1075 
                <ScalarProperty Name="TOTAL_PAGE" ColumnName="TOTAL_PAGE" />
1076 
                <ScalarProperty Name="CURRENT_PAGE" ColumnName="CURRENT_PAGE" />
1077 
                <ScalarProperty Name="EXCEPTION" ColumnName="EXCEPTION" />
1078 
                <ScalarProperty Name="END_DATETIME" ColumnName="END_DATETIME" />
1079 
                <ScalarProperty Name="START_DATETIME" ColumnName="START_DATETIME" />
1080 
                <ScalarProperty Name="DOCUMENT_ID" ColumnName="DOCUMENT_ID" />
1081 
              </MappingFragment>
1082 
            </EntityTypeMapping>
1083 
          </EntitySetMapping>
1084 1064 
          <EntitySetMapping Name="LOGIN_STAMP">
1085 1065 
            <EntityTypeMapping TypeName="MarkusDBModel.LOGIN_STAMP">
1086 1066 
              <MappingFragment StoreEntitySet="LOGIN_STAMP">
......
1273 1253 
              </MappingFragment>
1274 1254 
            </EntityTypeMapping>
1275 1255 
          </EntitySetMapping>
1256 
          <EntitySetMapping Name="FINAL_PDF">
1257 
            <EntityTypeMapping TypeName="MarkusDBModel.FINAL_PDF">
1258 
              <MappingFragment StoreEntitySet="FINAL_PDF">
1259 
                <ScalarProperty Name="DOCUMENT_ID" ColumnName="DOCUMENT_ID" />
1260 
                <ScalarProperty Name="START_DATETIME" ColumnName="START_DATETIME" />
1261 
                <ScalarProperty Name="END_DATETIME" ColumnName="END_DATETIME" />
1262 
                <ScalarProperty Name="EXCEPTION" ColumnName="EXCEPTION" />
1263 
                <ScalarProperty Name="CURRENT_PAGE" ColumnName="CURRENT_PAGE" />
1264 
                <ScalarProperty Name="TOTAL_PAGE" ColumnName="TOTAL_PAGE" />
1265 
                <ScalarProperty Name="STATUS" ColumnName="STATUS" />
1266 
                <ScalarProperty Name="CREATE_DATETIME" ColumnName="CREATE_DATETIME" />
1267 
                <ScalarProperty Name="CREATE_USER_ID" ColumnName="CREATE_USER_ID" />
1268 
                <ScalarProperty Name="MARKUPINFO_ID" ColumnName="MARKUPINFO_ID" />
1269 
                <ScalarProperty Name="DOCINFO_ID" ColumnName="DOCINFO_ID" />
1270 
                <ScalarProperty Name="PROJECT_NO" ColumnName="PROJECT_NO" />
1271 
                <ScalarProperty Name="ID" ColumnName="ID" />
1272 
              </MappingFragment>
1273 
            </EntityTypeMapping>
1274 
          </EntitySetMapping>
1276 1275 
        </EntityContainerMapping>
1277 1276 
      </Mapping>
1278 1277 
    </edmx:Mappings>

내보내기 Unified diff

클립보드 이미지 추가 (최대 크기: 500 MB)