• 고객센터
  • 교육
  • 매뉴얼
  • 데모
  • 제품소개
조회 수 : 996
2007.07.27 (00:33:55)

>금융 데이터를 핸들링 하는데
>
>약 5000건 정도 데이타인데 4줄마다 색깔 바뀌게끔 너주니까 너무 느리더라구요 더 좋은 방법이 없을까요?
>
>중략..
><script language=JavaScript for=dataset     event=OnLoadCompleted(rowCnt)>
>        
>        fn_alertLoadCompleted(dataset,rowCnt);
>        window.status = "조회 건수는 " + rowCnt + "건 입니다.";        
>        for(i=1; i<=rowCnt ; i++){
>                var modColor=0;
>                        
>                modColor = i % 8;
>                                
>                //dataset.NameValue(i,"bgcol")= modColor;
>                
>        }
>중략..
><fc> id='samuso_nm',      name='사무소명', width=160, headbgcolor='#CCE6F6', align='left', HeadColor='#0C3F5B', suppress = '1' bgColor={Decode(bgCol,'1','#EFE38F','2','#EFE38F','3','#EFE38F','4','#EFE38F','#ffffff')}</fc>
>            <fc> id='j_gbn',          name='구  분', width=80,    headbgcolor='#CCE6F6', align='center', HeadColor='#0C3F5B' bgColor={Decode(bgCol,'1','#EFE38F','2','#EFE38F','3','#EFE38F','4','#EFE38F','#ffffff')}</fc>
>            <c> id='day_1',           name='01일', width=70,     headbgcolor='#CCE6F6', align='center', HeadColor='#0C3F5B'  bgColor={Decode(bgCol,'1','#EFE38F','2','#EFE38F','3','#EFE38F','4','#EFE38F','#ffffff')}</c>
>            <c> id='day_2',           name='02일', width=70,     headbgcolor='#CCE6F6', align='center', HeadColor='#0C3F5B'  bgColor={Decode(bgCol,'1','#EFE38F','2','#EFE38F','3','#EFE38F','4','#EFE38F','#ffffff')}</c>
>            <c> id='day_3',           name='03일', width=70,     headbgcolor='#CCE6F6', align='center', HeadColor='#0C3F5B'  bgColor={Decode(bgCol,'1','#EFE38F','2','#EFE38F','3','#EFE38F','4','#EFE38F','#ffffff')}</c>
>            <c> id='day_4',           name='04일', width=70,     headbgcolor='#CCE6F6', align='center', HeadColor='#0C3F5B'  bgColor={Decode(bgCol,'1','#EFE38F','2','#EFE38F','3','#EFE38F','4','#EFE38F','#ffffff')}</c>
>            <c> id='day_5',           name='05일', width=70,     headbgcolor='#CCE6F6', align='center', HeadColor='#0C3F5B'  bgColor={Decode(bgCol,'1','#EFE38F','2','#EFE38F','3','#EFE38F','4','#EFE38F','#ffffff')}</c>
>            <c> id='day_6',           name='06일', width=70,     headbgcolor='#CCE6F6', align='center', HeadColor='#0C3F5B'  bgColor={Decode(bgCol,'1','#EFE38F','2','#EFE38F','3','#EFE38F','4','#EFE38F','#ffffff')}</c>
>            <c> id='day_7',           name='07일', width=70,     headbgcolor='#CCE6F6', align='center', HeadColor='#0C3F5B'  bgColor={Decode(bgCol,'1','#EFE38F','2','#EFE38F','3','#EFE38F','4','#EFE38F','#ffffff')}</c>
>            <c> id='day_8',           name='08일', width=70,     headbgcolor='#CCE6F6', align='center', HeadColor='#0C3F5B'  bgColor={Decode(bgCol,'1','#EFE38F','2','#EFE38F','3','#EFE38F','4','#EFE38F','#ffffff')}</c>
>            <c> id='day_9',           name='09일', width=70,     headbgcolor='#CCE6F6', align='center', HeadColor='#0C3F5B'  bgColor={Decode(bgCol,'1','#EFE38F','2','#EFE38F','3','#EFE38F','4','#EFE38F','#ffffff')}</c>
>            <c> id='day_10',          name='10일', width=70,     headbgcolor='#CCE6F6', align='center', HeadColor='#0C3F5B'  bgColor={Decode(bgCol,'1','#EFE38F','2','#EFE38F','3','#EFE38F','4','#EFE38F','#ffffff')}</c>
>            <c> id='day_11',          name='11일', width=70,     headbgcolor='#CCE6F6', align='center', HeadColor='#0C3F5B'  bgColor={Decode(bgCol,'1','#EFE38F','2','#EFE38F','3','#EFE38F','4','#EFE38F','#ffffff')}</c>
>            <c> id='day_12',          name='12일', width=70,     headbgcolor='#CCE6F6', align='center', HeadColor='#0C3F5B'  bgColor={Decode(bgCol,'1','#EFE38F','2','#EFE38F','3','#EFE38F','4','#EFE38F','#ffffff')}</c>
>            <c> id='day_13',          name='13일', width=70,     headbgcolor='#CCE6F6', align='center', HeadColor='#0C3F5B'  bgColor={Decode(bgCol,'1','#EFE38F','2','#EFE38F','3','#EFE38F','4','#EFE38F','#ffffff')}</c>
>            <c> id='day_14',          name='14일', width=70,     headbgcolor='#CCE6F6', align='center', HeadColor='#0C3F5B'  bgColor={Decode(bgCol,'1','#EFE38F','2','#EFE38F','3','#EFE38F','4','#EFE38F','#ffffff')}</c>
>            <c> id='day_15',          name='15일', width=70,     headbgcolor='#CCE6F6', align='center', HeadColor='#0C3F5B'  bgColor={Decode(bgCol,'1','#EFE38F','2','#EFE38F','3','#EFE38F','4','#EFE38F','#ffffff')}</c>
>            <c> id='day_16',          name='16일', width=70,     headbgcolor='#CCE6F6', align='center', HeadColor='#0C3F5B'  bgColor={Decode(bgCol,'1','#EFE38F','2','#EFE38F','3','#EFE38F','4','#EFE38F','#ffffff')}</c>
>            <c> id='day_17',          name='17일', width=70,     headbgcolor='#CCE6F6', align='center', HeadColor='#0C3F5B'  bgColor={Decode(bgCol,'1','#EFE38F','2','#EFE38F','3','#EFE38F','4','#EFE38F','#ffffff')}</c>
>            <c> id='day_18',          name='18일', width=70,     headbgcolor='#CCE6F6', align='center', HeadColor='#0C3F5B'  bgColor={Decode(bgCol,'1','#EFE38F','2','#EFE38F','3','#EFE38F','4','#EFE38F','#ffffff')}</c>
>            <c> id='day_19',          name='19일', width=70,     headbgcolor='#CCE6F6', align='center', HeadColor='#0C3F5B'  bgColor={Decode(bgCol,'1','#EFE38F','2','#EFE38F','3','#EFE38F','4','#EFE38F','#ffffff')}</c>
>            <c> id='day_20',          name='20일', width=70,     headbgcolor='#CCE6F6', align='center', HeadColor='#0C3F5B'  bgColor={Decode(bgCol,'1','#EFE38F','2','#EFE38F','3','#EFE38F','4','#EFE38F','#ffffff')}</c>
>            <c> id='day_21',          name='21일', width=70,     headbgcolor='#CCE6F6', align='center', HeadColor='#0C3F5B'  bgColor={Decode(bgCol,'1','#EFE38F','2','#EFE38F','3','#EFE38F','4','#EFE38F','#ffffff')}</c>
>            <c> id='day_22',          name='22일', width=70,     headbgcolor='#CCE6F6', align='center', HeadColor='#0C3F5B'  bgColor={Decode(bgCol,'1','#EFE38F','2','#EFE38F','3','#EFE38F','4','#EFE38F','#ffffff')}</c>
>            <c> id='day_23',          name='23일', width=70,     headbgcolor='#CCE6F6', align='center', HeadColor='#0C3F5B'  bgColor={Decode(bgCol,'1','#EFE38F','2','#EFE38F','3','#EFE38F','4','#EFE38F','#ffffff')}</c>
>            <c> id='day_24',          name='24일', width=70,     headbgcolor='#CCE6F6', align='center', HeadColor='#0C3F5B'  bgColor={Decode(bgCol,'1','#EFE38F','2','#EFE38F','3','#EFE38F','4','#EFE38F','#ffffff')}</c>
>            <c> id='day_25',          name='25일', width=70,     headbgcolor='#CCE6F6', align='center', HeadColor='#0C3F5B'  bgColor={Decode(bgCol,'1','#EFE38F','2','#EFE38F','3','#EFE38F','4','#EFE38F','#ffffff')}</c>
>            <c> id='day_26',          name='26일', width=70,     headbgcolor='#CCE6F6', align='center', HeadColor='#0C3F5B'  bgColor={Decode(bgCol,'1','#EFE38F','2','#EFE38F','3','#EFE38F','4','#EFE38F','#ffffff')}</c>
>            <c> id='day_27',          name='27일', width=70,     headbgcolor='#CCE6F6', align='center', HeadColor='#0C3F5B'  bgColor={Decode(bgCol,'1','#EFE38F','2','#EFE38F','3','#EFE38F','4','#EFE38F','#ffffff')}</c>
>            <c> id='day_28',          name='28일', width=70,     headbgcolor='#CCE6F6', align='center', HeadColor='#0C3F5B'  bgColor={Decode(bgCol,'1','#EFE38F','2','#EFE38F','3','#EFE38F','4','#EFE38F','#ffffff')}</c>
>            <c> id='day_29',          name='29일', width=70,     headbgcolor='#CCE6F6', align='center', HeadColor='#0C3F5B'  bgColor={Decode(bgCol,'1','#EFE38F','2','#EFE38F','3','#EFE38F','4','#EFE38F','#ffffff')}</c>
>            <c> id='day_30',          name='30일', width=70,     headbgcolor='#CCE6F6', align='center', HeadColor='#0C3F5B'  bgColor={Decode(bgCol,'1','#EFE38F','2','#EFE38F','3','#EFE38F','4','#EFE38F','#ffffff')}</c>
>            <c> id='day_31',          name='31일', width=70,     headbgcolor='#CCE6F6', align='center', HeadColor='#0C3F5B'  bgColor={Decode(bgCol,'1','#EFE38F','2','#EFE38F','3','#EFE38F','4','#EFE38F','#ffffff')}</c>
>            <c> id='day_tot',         name='합계', width=70,     headbgcolor='#CCE6F6', align='center', HeadColor='#0C3F5B'  bgColor={Decode(bgCol,'1','#EFE38F','2','#EFE38F','3','#EFE38F','4','#EFE38F','#ffffff')}</c>
>        


아무래도 decode 문을 많이 사용하시면... 내부적으로 연산이 많이 일어나게 되어..

느려질 수 있습니다..

이런 경우.. 미리 DB 에서.. color 컬럼을 만들어와서.. 변수처럼 사용하시면 될 듯합니다..

자세한 내용은 컴포넌트 메뉴얼의

Grid - Columnprop - bgcolor 항목을 참조하시기 바랍니다.
 
Tag List
XE Login