글 수 7,449
기술지원44
조회 수 : 24642
2008.10.09 (00:20:17)
>게시판을 이용해 주셔서 감사합니다.
>다음양식에 맞게 입력해주세요.
>
>* 고객시스템명 : 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>
유선으로 통화했을시..
firstrow 사이즈를 250 정도로 조정해 보라고 얘기드렸습니다.
http://member.shift.co.kr/index.php?document_srl=235396
(*.124.184.82)
|
|
