• 고객센터
  • 교육
  • 매뉴얼
  • 데모
  • 제품소개
글 수 7,449

그리드 화면에 출력시 너무 오래 걸립니다.

안영수
조회 수 : 1467
2008.10.08 (19:12:53)
게시판을 이용해 주셔서 감사합니다.
다음양식에 맞게 입력해주세요.

* 고객시스템명 : LG PU-SIS
* GAUCE 버전 : 3.X
* WAS 종류(WebLogic 등등) : Weblogic
* DB 종류 : oracle
* 문의 유형(질문/요청/참조) : 질문
* 내용 :
안녕하세요
가우스 그리드에 디비에서 select 한 내용을 그리드에 보여 주고 있는데
쿼리는 7초 정도가 걸립니다. 로우건수는 17000건 정도 됩니다.
그리드에 다 부려주는데 4-5분 정도가 걸립니다.
원래 이렇게 오래걸리나요 ..?
이렇게 셋팅해서 뿌리고 있습니다.
답변 부탁 드립니다
   <OBJECT id='tb_Grid' class='defaultgrid' WIDTH='<%=LGPIKeys.L_GAUCE_GRID_MIN_WIDTH%>' HEIGHT='<%=LGPIKeys.L_GAUCE_GRID_HEIGHT%>' classid=clsid:1F57AEAD-DB12-11D2-A4F9-00608CEBEE49 VIEWASTEXT codebase="/ocx/toinbgrid.cab">
                            <PARAM NAME="DataID" VALUE="tb_DataSet">
                <PARAM NAME="ColSizing"           value="true">
                <PARAM NAME="SortView"            value="RIGHT">
                <PARAM NAME="FixSizing"           value="true">
                <PARAM NAME="TitleHeight"         value=26>
                <PARAM NAME="IndicatorBkColor"    value="<%=LGPIKeys.L_C_HBGCOLOR%>">
                <PARAM NAME="IndicatorColBkColor" value="<%=LGPIKeys.L_C_HBGCOLOR%>">
                <PARAM NAME="Format" VALUE='
                        <FC> Name = "Part No"              ID = PART_NO    suppress=2   edit=none HeadAlign=Center HeadBgColor=<%=LGPIKeys.L_C_HBGCOLOR3%> Width=100   Align=LEFT    sort=true   BgColor=<%=LGPIKeys.L_FBGCOLOR01%>  </FC>
                        <FC> Name = "Market"               ID = MARKET     suppress=1   edit=none HeadAlign=Center HeadBgColor=<%=LGPIKeys.L_C_HBGCOLOR3%> Width=100   Align=CENTER  sort=true   BgColor=<%=LGPIKeys.L_FBGCOLOR01%>  </FC>                                        
                         <C> Name = "Description"          ID = DESCRIPTION             edit=none HeadAlign=Center HeadBgColor=<%=LGPIKeys.L_C_HBGCOLOR%>  Width=140   Align=LEFT       BgColor=@acolor  </C>                                  
                         <C> Name = "Spec"                 ID = SPEC                    edit=none HeadAlign=Center HeadBgColor=<%=LGPIKeys.L_C_HBGCOLOR%>  Width=200   Align=LEFT       BgColor=@acolor  </C>                      
                         <C> Name = "CMDT Code"            ID = CMDT_CODE               edit=none HeadAlign=Center HeadBgColor=<%=LGPIKeys.L_C_HBGCOLOR%>  Width=100   Align=CENTER     BgColor=@acolor  </C>
                         <C> Name = "CMDT Name"            ID = CMDT_NAME               edit=none HeadAlign=Center HeadBgColor=<%=LGPIKeys.L_C_HBGCOLOR%>  Width=150   Align=LEFT       BgColor=@acolor  </C>
                         <C> Name = "Company"              ID = COMPANY                 edit=none HeadAlign=Center HeadBgColor=<%=LGPIKeys.L_C_HBGCOLOR%>  Width=100   Align=CENTER     BgColor=@acolor  </C>
                         <C> Name = "Sub Division"         ID = DIVISION                edit=none HeadAlign=Center HeadBgColor=<%=LGPIKeys.L_C_HBGCOLOR%>  Width=100   Align=CENTER     BgColor=@acolor  </C>
                         <C> Name = "Sub Division Name"    ID = DIVISION_NAME           edit=none HeadAlign=Center HeadBgColor=<%=LGPIKeys.L_C_HBGCOLOR%>  Width=160   Align=LEFT       BgColor=@acolor  </C>
                         <C> Name = "OrderRate(%)"         ID = ORDER_RATE              edit=none HeadAlign=Center HeadBgColor=<%=LGPIKeys.L_C_HBGCOLOR%>  Width=110   Align=RIGHT      BgColor=@acolor  </C>
                         <C> Name = "LPK"                  ID = LPK                     edit=none HeadAlign=Center HeadBgColor=<%=LGPIKeys.L_C_HBGCOLOR%>  Width=50    Align=CENTER     BgColor=@acolor  </C>
                         <C> Name = "Line Type"            ID = LINE_TYPE               edit=none HeadAlign=Center HeadBgColor=<%=LGPIKeys.L_C_HBGCOLOR%>  Width=80    Align=CENTER     BgColor=@acolor  </C>
                         <C> Name = "Currency"             ID = CURRENCY                edit=none HeadAlign=Center HeadBgColor=<%=LGPIKeys.L_C_HBGCOLOR%>  Width=80    Align=CENTER     BgColor=@acolor  </C>
                         <C> Name = "Price"                ID = PRICE                   edit=none HeadAlign=Center HeadBgColor=<%=LGPIKeys.L_C_HBGCOLOR%>  Width=80    Align=RIGHT      BgColor=@acolor  </C>
                         <C> Name = "Start Date"           ID = START_DATE              edit=none HeadAlign=Center HeadBgColor=<%=LGPIKeys.L_C_HBGCOLOR%>  Width=80    Align=CENTER     BgColor=@acolor  </C>
                         <C> Name = "Exchange Rate"        ID = EXCHANGE_RATE           edit=none HeadAlign=Center HeadBgColor=<%=LGPIKeys.L_C_HBGCOLOR%>  Width=140   Align=RIGHT      BgColor=@acolor  </C>
                         <C> Name = "Conv Price($)"        ID = CONV_PRICE              edit=none HeadAlign=Center HeadBgColor=<%=LGPIKeys.L_C_HBGCOLOR%>  Width=120   Align=RIGHT      BgColor=@acolor  </C>
                         <C> Name = "Qty"                  ID = QTY                     edit=none HeadAlign=Center HeadBgColor=<%=LGPIKeys.L_C_HBGCOLOR%>  Width=100   Align=RIGHT      BgColor=@acolor  </C>
                         <C> Name = "Supplier Code"        ID = SUPPLIER_CODE           edit=none HeadAlign=Center HeadBgColor=<%=LGPIKeys.L_C_HBGCOLOR%>  Width=100   Align=LEFT       BgColor=@acolor  </C>
                         <C> Name = "Supplier Name (KOR)"  ID = SUPPLIER_NAME_KOR       edit=none HeadAlign=Center HeadBgColor=<%=LGPIKeys.L_C_HBGCOLOR%>  Width=200   Align=LEFT       BgColor=@acolor  </C>
                         <C> Name = "Supplier Name (USD)"  ID = SUPPLIER_NAME_ENG       edit=none HeadAlign=Center HeadBgColor=<%=LGPIKeys.L_C_HBGCOLOR%>  Width=200   Align=LEFT       BgColor=@acolor  </C>
                         <C> Name = "Developer Group"      ID = DEVELOPER_GROUP         edit=none HeadAlign=Center HeadBgColor=<%=LGPIKeys.L_C_HBGCOLOR%>  Width=120   Align=LEFT       BgColor=@acolor  </C>
                         <C> Name = "Developer"            ID = DEVELOPER               edit=none HeadAlign=Center HeadBgColor=<%=LGPIKeys.L_C_HBGCOLOR%>  Width=140   Align=LEFT       BgColor=@acolor  </C>
                '>                
             </OBJECT>
                         </comment> <script>__ws__(__NSID__);</script>
이 게시물을...
http://member.shift.co.kr/index.php?document_srl=235397 (*.247.145.8)
댓글 [0]
  목록
 
첫 페이지 157 158 159 160 161 162 163 164 165 166 끝 페이지
Tag List
목록 쓰기
XE Login