* °³¿ä
º¸°í¼¿¡ º¸¿©Áú µ¥ÀÌÅÍ°¡ ´ë¿ë·®ÀÎ °æ¿ì ºä¾î È£ÃâÇÏ´Â Æз¯¹ÌÅ͸¦ Á¶ÀýÇÏ¿© ºü¸¥ ¼Óµµ·Î º¸°í¼°¡ È£ÃâµÇ¸é¼
¸Þ¸ð¸®¸¦ Àû°Ô »ç¿ëÇϵµ·Ï ¼³Á¤ÇÒ ¼ö ÀÖ½À´Ï´Ù.
* »ó¼¼ ¼³¸í
¾Æ·¡°ú °°Àº ºä¾î Æз¯¹ÌÅ͸¦ ¼³Á¤ÇÏ½Ã¸é ´ë¿ë·®ÀÇ º¸°í¼¸¦ ó¸®ÇÏ½Ç ¼ö ÀÖ½À´Ï´Ù.
(´ë¿ë·® ºä¾î Æз¯¹ÌÅÍ)
<param name="connection.fetchtype" value="CONCURRENT">
<param name="connection.pageque" value="-500">
<param name="connection.serverdmtype" value="MEMORY ">
<param name="connection.clientdmtype" value="MEMORY">
<param name="connection.compresseddatamodule" value="false">
<param name="connection.compressedForm" value="false"> |
¾Æ·¡ ÀÚ¼¼ÇÑ ¼³¸íÀ» º¸°í Æз¯¹ÌÅÍ °ªÀ» Á¶Àý ÇϽñ⠹ٶø´Ï´Ù.
Âü°í·Î ¿ÀÁî ¼¹ö ¼³Á¤ ÆÄÀÏ(conf/ÇÏÀ§¿¡ ÀÖ´Â *.properties ÆÄÀÏ)ÀÌ º¯°æµÇ´Â ºÎºÐÀÌ ÀÖÀ» °æ¿ì ¿ÀÁî ¼¹ö¸¦ À籸µ¿ ÇÏ¼Å¾ß ¹Ý¿µµË´Ï´Ù.
[connection.fetchtype]
<param name="connection.fetchtype" value="CONCURRENT"> <param name="connection.fetchtype" value="BATCH"> |
(±âº»°ª : BATCH)
¼¹ö¿¡¼ Á¶È¸µÈ µ¥ÀÌÅ͸¦ Ŭ¶óÀ̾ðÆ®¿¡ ½Ç½Ã°£À¸·Î º¸³¾¶§´Â CONCURRENT·Î ¼³Á¤ÇÏ°í Çѹø¿¡ º¸³»·Á¸é BATCH·Î ¼³Á¤ÇÕ´Ï´Ù. CONCURRENT·Î ÇÏ¸é µ¥ÀÌÅ͸¦ ½Ç½Ã°£À¸·Î ¼¹ö¿¡¼ ºä¾î·Î Àü¼ÛÇϱ⠶§¹®¿¡ ºä¾î°¡ ¸ÕÀú ÀÛ¾÷ÇÒ ¼ö ÀÖ°Ô µË´Ï´Ù. ±×·¡¼ ºä¾î¿¡ ùÆäÀÌÁö°¡ ¹Ù·Î º¸¿©Áú ¼ö ÀÖ½À´Ï´Ù. ¹Ý¸é BATCH·Î ÇÏ°Ô µÇ¸é Çѹø¿¡ µ¥ÀÌÅ͸¦ ºä¾î·Î º¸³»±â ¶§¹®¿¡ ºä¾î¿¡¼ÀÇ Ã¹ÆäÀÌÁö ¶ß´Â °ÍÀº ´õ ´Ê°Ô µË´Ï´Ù. ±×¸®°í BATCH·Î ÇÏ°Ô µÇ¸é ¼¹ö ¸Þ¸ð¸®¸¦ ¸¹ÀÌ Â÷ÁöÇÏ°Ô µË´Ï´Ù.
³×Æ®¿öÅ© ¼Óµµ°¡ ´À¸®¸é BATCH¸¦ °í·ÁÇÒ ¼öµµ ÀÖÀ¸³ª »ç³» ³×Æ®웤¸ÁÀÌ°í ¼Óµµ°¡ ºü¸¥ÆíÀ̶ó¸é CONCURRENT·Î ÇÏ´Â ÆíÀÌ ÁÁÀ» °Í °°½À´Ï´Ù.
CONCURRENTÀÇ °æ¿ì ¼¹öÂÊ conf/databind.propertiesÀÇ ConcurrentFetchSize=4096 ÀÇ Å©±â ¸¸Å ºä¾î·Î Àü¼ÛµÇ±â ¶§¹®¿¡ ÀÌ °ªÀ» ¹Ù²Ù¾î ¼Óµµ Å×½ºÆ® ÇÒ ÇÊ¿äµµ ÀÖ½À´Ï´Ù.
[connection.serverdmtype]
<param name="connection.serverdmtype" value="MEMORY">
<param name="connection.serverdmtype" value="FILE"> |
(±âº»°ª : MEMORY)
¼¹ö¿¡¼ µ¥ÀÌÅ͸¦ ¸Þ¸ð¸®¿¡ µÑÁö ÆÄÀÏ·Î µÑÁö ¼³Á¤ÇÏ´Â ¿É¼ÇÀÔ´Ï´Ù.
µ¥ÀÌÅ͸¦ SDMÆÄÀÏ·Î ¸¸µé¾úÀ» ¶§ÀÇ »çÀÌÁî Á¤µµ¸¦ ¼¹ö ¸Þ¸ð¸®°¡ »ç¿ëÇÑ´Ù°í »ý°¢ÇÏ¸é µË´Ï´Ù. FILEº¸´Ù MEMORY·Î ó¸®Çϸé FILE I/O ½Ã°£ÀÌ ÁÙ¾îµé±â ¶§¹®¿¡ MEMORY·Î ó¸®Çϸé ÁÁÀ» °Í °°½À´Ï´Ù.
[connection.clientdmtype]
<param name="connection.clientdmtype" value="MEMORY">
<param name="connection.clientdmtype" value="FILE"> |
(±âº»°ª : MEMORY)
Ŭ¶óÀ̾ðÆ® PC¿¡¼ ¼¹ö·ÎºÎÅÍ ¹ÞÀº µ¥ÀÌÅ͸¦ ¸Þ¸ð¸®¿¡ µÑÁö ÆÄÀÏ·Î µÑÁö ¼³Á¤ÇÏ´Â ¿É¼ÇÀÔ´Ï´Ù.
µ¥ÀÌÅ͸¦ SDMÆÄÀÏ·Î ¸¸µé¾úÀ» ¶§ ¾ÐÃàÇÑ SDMÆÄÀÏ »çÀÌÁî Á¤µµ¸¦ Ŭ¶óÀ̾ðÆ® ¸Þ¸ð¸®°¡ »ç¿ëÇÑ´Ù°í »ý°¢ÇÏ¸é µË´Ï´Ù.
FILEº¸´Ù MEMORY·Î ó¸®Çϸé FILE I/O ½Ã°£ÀÌ ÁÙ¾îµé±â ¶§¹®¿¡ MEMORY·Î ÇÏ´Â °ÍÀÌ ¼Óµµ¸é¿¡¼ ºü¸¨´Ï´Ù.
[connection.pageque]
<param name="connection.pageque" value="-1000">
<param name="connection.pageque" value="0"> |
(±âº»°ª : 0)
ºä¾î¿¡¼ ¹ÙÀεùÀÌ ¿Ï·áµÈ º¸°í¼ ÆäÀÌÁö¿¡ ´ëÇØ ¸Þ¸ð¸®¿¡ ÀúÀåÇÒ Áö ÆÄÀÏ·Î ÀúÀåÇÒ Áö ¼³Á¤ÇÒ ¶§ »ç¿ëÇÏ´Â ¿É¼ÇÀÔ´Ï´Ù.
°ªÀÌ 0ÀÌ¸é ¸ðµÎ ¸Þ¸ð¸®¿¡ ÀúÀåµÇ³ª ¼ýÀÚ¸¦ ÁÖ°Ô µÇ¸é ÇØ´ç ¼ýÀÚ¸¸ÅÀÇ ÆäÀÌÁö¸¸ ¸Þ¸ð¸®¿¡ ¿Ã¸®°í ³ª¸ÓÁö ÆäÀÌÁö´Â opzÀ̶õ ÆÄÀÏ·Î ¾ÐÃàÇÏ¿© ÀúÀåÇÕ´Ï´Ù.
+. - ´Â ¿¹Àü¿¡´Â -¸¦ ÁÖ¾î¾ß¸¸ ÆÄÀÏ·Î ÀúÀåÇÑ ÆäÀÌÁö¸¦ ¾ÐÃàÇß¾úÀ¸³ª ¿äÁò ºä¾î´Â pageque ¼öÄ¡ °ª¿¡ -¸¦ ÁÖ³ª ¾ÈÁÖ³ª ÆÄÀÏÀÌ ¾ÐÃàµË´Ï´Ù. Ŭ¶óÀ̾ðÆ® ¸Þ¸ð¸® »ç¾çÀÌ ÁÁÀº °æ¿ì ¼öÄ¡¸¦ ³ôÀÏ ¼ö·Ï ÆÄÀÏ·Î ÀúÀåÇÏ´Â ÆäÀÌÁö¼ö°¡ Áٱ⠶§¹®¿¡ ¼Óµµ°¡ »¡¶óÁø´Ù°í º¼ ¼ö ÀÖ½À´Ï´Ù. ´ë¿ë·® º¸°í¼ÀÇ °æ¿ì ¼öÄ¡¸¦ ³ô¿© ÃÖÀûÀÇ ¼öÄ¡¸¦ ÃøÁ¤ÇØ¾ß ÇÕ´Ï´Ù. ½Ç¾÷¹«¿¡ Àû¿ëÇÏ½Ç ¶§¿¡´Â pageque°ªÀ» ³ô¿©º¸¸é¼ Á¶ÀýÇÏ¿© ÇØ´ç ´ë¿ë·® º¸°í¼¸¦ Ŭ¶óÀ̾ðÆ®¿¡¼ ¾î´À Á¤µµ±îÁö ¸Þ¸ð¸® »ç¿ëÀÌ °¡´ÉÇÑÁö Å×½ºÆ®¸¦ ÇغÁ¾ß ÇÕ´Ï´Ù.
[connection.compresseddatamodule, connection.compressedForm]
<param name="connection.compresseddatamodule" value="false"> <param name="connection.compressedForm" value="false"> |
(±âº»°ª : false) µ¥ÀÌÅÍ¿Í ÆûÀ» ¾ÐÃàÇÒÁö ¿©ºÎ¸¦ ¼³Á¤ÇÏ´Â ¿É¼ÇÀÔ´Ï´Ù. ³×Æ®웤ÀÌ ´À¸° ȯ°æ¿¡¼´Â »çÀÌÁ ÁÙÀ̱â À§ÇØ ¾ÐÃàÇÏ·Á¸é true·Î ¼³Á¤ÇÒ ¼ö ÀÖ½À´Ï´Ù. ³×Æ®웤ÀÌ ºü¸¥ ȯ°æ¿¡¼´Â false·Î Çصµ º°·Î ¿µÇâÀÌ ¾ø½À´Ï´Ù.
¾Æ·¡ÀÇ ¼³Á¤Àº ´ë¿ë·® º¸°í¼¿¡ Å©°Ô ¿µÇâÀ» ¹ÌÄ¡Áö´Â ¾ÊÀ¸¸ç Âü°í¸¸ ÇÏ½Ã¸é µË´Ï´Ù.
[ODI]
º¸°í¼ µðÀÚÀνà »ç¿ëÇÏÁö ¾Ê´Â µ¥ÀÌÅÍ ÇʵåÀÇ °æ¿ì ODIÀÇ Äõ¸®¹®À» ¼öÁ¤ÇÏ¿© µ¥ÀÌÅͼÂÀ¸·Î °¡Á®¿ÀÁö ¾Êµµ·Ï ÇÕ´Ï´Ù. ºÒÇÊ¿äÇÑ µ¥ÀÌÅ͸¦ °¡Á®¿ÀÁö ¾Êµµ·Ï ÇÏ¸é ¼¹ö¿¡¼ ¹Þ´Â µ¥ÀÌÅÍ ¾çÀ» ÁÙÀÏ ¼ö ÀÖ½À´Ï´Ù.
[¼¹ö ¼³Á¤ üũ]
# Set Prioritylog level # # DEBUG, INFO, WARN, ERROR Priority=ERROR // ERROR¸ðµå·Î #Priority=ERROR |
¿ÀÁî¼¹öȨ/conf/log.propertiesÀÇ ³»¿ë¿¡¼ ¿ÀÁî¼¹ö ·Î±×°¡ ¸¹ÀÌ ³²´Â °æ¿ì¿¡´Â(Á¢¼ÓÀÚ ¼ö ¹× Äõ¸®, º¸°í¼ ¿äû ¼ö°¡ ¸¹À¸¸é) ·Î±×¸¦ DEBUG¿¡¼ ERROR·Î ÇÏ¸é ¿¡·¯³ °æ¿ì¿¡ ´ëÇؼ¸¸ ·Î±×°¡ ³²½À´Ï´Ù.
[ºä¾îÄַܼα×]
<param name="information.debug" value="false"> <param name="information.debug" value="true"> |
½ºÅ©¸³Æ® ¿¡·¯°¡ ¹ß»ýÇÏ´Â ´ë¿ë·® º¸°í¼ÀÇ °æ¿ì ½ºÅ©¸³Æ® ¿¡·¯°¡ ¼öõ¶óÀαîÁö °¡´Â »óȲÀÌ ¹ß»ýÇÒ ¼öµµ ÀÖ½À´Ï´Ù. ÀÌ·± °æ¿ì¿¡´Â Ctrl+Z·Î ÄܼÖâÀ» ¶ç¿ï ¶§ ·Îµù ¼Óµµ°¡ ´À·ÁÁý´Ï´Ù.
(º¸°í¼ ½ÇÇà ÅÂ±× È£ÃâÇÏ´Â HTML)
<html> <body> <OBJECT ID="ZTransferX" width = "0" height = "0" CLASSID="CLSID:C7C7225A-9476-47AC-B0B0-FF3B79D55E67" codebase="http://127.0.0.1:8080/oz35/ozrviewer/ZTransferX.cab#version=2,1,1,1"> <PARAM NAME="download.Server" VALUE="http://127.0.0.1/oz35/ozrviewer"> <PARAM NAME="download.Port" VALUE="8080"> <PARAM NAME="download.Instruction" VALUE="ozrviewer.idf"> <PARAM NAME="install.Base" VALUE="<PROGRAMS>/Forcs"> <param name="install.NameSpace" value="viewerName"> </object> <object id="ozviewer" width="800" height="600" CLASSID="CLSID:0DEF32F8-170F-46f8-B1FF-4BF7443F5F25"> <param name="connection.servlet" value="http://127.0.0.1:8080/oz35/server"> <param name="connection.reportname" value="/big.ozr"> <param name="viewer.configmode" value="html">
<param name="viewer.namespace" value="viewerName\ozviewer">
<!-- ´ë¿ë·® ¿É¼Ç -->
<param name="connection.fetchtype" value="CONCURRENT">
<param name="connection.pageque" value="-700">
<param name="connection.serverdmtype" value="MEMORY">
<param name="connection.clientdmtype" value="MEMORY">
<param name="connection.compresseddatamodule" value="false">
<param name="connection.compressedForm" value="false">
</object> </body> </html> |
* Âü°í »çÇ×
"OZ Report Viewer User's Guide.pdf" ¹®¼(http://oztn.net/kb/article/mannual/119181943059310)ÀÇ "´ë¿ë·® µ¥ÀÌÅÍ º¸°í¼ ¹Ì¸®º¸±â"(113 ÆäÀÌÁö)¿¡ ´ë¿ë·® ºä¾î Æз¯¹ÌÅÍ¿¡ ´ëÇÑ ¼³¸íÀÌ ÀÖ½À´Ï´Ù.
* Âü°í»çÇ× : ´ë¿ë·® º¸°í¼ ¿î¿µ ½Ã clientdmtypeÀ» "MEMORY"³ª "FILE"·Î ¼³Á¤ÇÏ¿© º´·Ä 󸮸¦ ¼±ÅÃÇÏ°í fetchtypeÀ» "CONCURRENT"·Î ¼³Á¤ÇÏ¿© ¼¹ö¿¡¼ ½Ç½Ã°£À¸·Î µ¥ÀÌÅÍ ¸ðµâÀ» Àü¼ÛÇϵµ·Ï ¼³Á¤ÇÏ´õ¶óµµ ´ÙÀ½°ú °°Àº °æ¿ì Àüü º¸°í¼ ¹ÙÀεùÀÌ ¿Ï·áµÈ ½ÃÁ¡¿¡¼ º¸°í¼ ù ÆäÀÌÁö°¡ ¶ß°Ô µË´Ï´Ù.
- Â÷Æ®, °£Æ® Â÷Æ®, Å©·Î½ºÅÇ, Å×ÀÌºí º¸°í¼ÀÇ °æ¿ì
- ¶óº§À̳ª ¼ö½Ä ÇÊµå µîÀÇ ½ºÅ©¸³Æ®¿¡¼ ´ÙÀ½°ú °°Àº ÇÔ¼ö¸¦ »ç¿ëÇÒ °æ¿ì :
dbsum, dbavg, dbmax, dbmin, dbfreg, TotalRowCount
|