ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[­ì³Ð] §Ö³tí©w±Æ§Çªk´ú¸Õ

¥»©«³Ì«á¥Ñ jackyq ©ó 2017-2-12 22:23 ½s¿è

10000x2  = 0.198¬í ºâºC¤F
±Æ§Ç¦pªG¥Î±o«Ü¥û
À³¸Ó­n¥Î VC «Ê¸Ë1¤U
·|¬O 0.198¬í ªº 10 ­¿³t

TOP

°÷¥Î´N¦n

¨C­Ó¤H CPU µ¥¯Å¤£¤@¼Ë
¥u¯à¦Û¤v©M¦Û¤v¤ñ
­pºâ¶q 720¸Uµ§
EXCEL + VBA  ¤£Ã­±Æ = 15.567 sec
EXCEL + VBA      Ã­±Æ = 18.398 sec
EXCEL + VC    ¤£Ã­±Æ   =   1.547 sec
EXCEL + VC        Ã­±Æ   =   1.603 sec

TOP

http://jackyq.pixnet.net/blog/post/103456672-2017_02_14

TOP

(1) ¥Î value ·|¤ñ¸û§Ö
(2) ·íªì¬O¦]¬°¦b§Aªº2ºûSub´ú AR2D( 1¸U , 300 ) ,¬Ý¤@¤U Ram ³Ì°ª®p¥i¥HÃz¨ì 600 MB, ¤~¥[¤W¥h
  ²{¦b Sub ¤w¸g§ï¦¨1ºû, »¼°j©Ò»Ý¶q¤j·§·|­°¬° 600 MB / 300 = 2 MB , ¥i¥H®³±¼ ReDim Preserve ·|¤ñ¸û§Ö  
(3)  UBound(­ì©l¤Gºû°}¦C, 2) ¤]¥ý¥N¤JÅܼƷ|¤ñ¸û§Ö, ¦ý³q±`µL·P

TOP

        ÀR«ä¦Û¦b : ­×¦æ­nô½t­×¤ß¡AÂǨƽm¤ß¡AÀH³B¾i¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD