[Seasar-user:16326] Re: テーブル項目追加に伴うパフォーマンス低下についてのご質問

[Kobayashi.Tomomi]

$B$*@$OC$K$J$j$^$9!#(B
$B$42sEz$"$j$,$H$&8f:B$$$^$9!#(B

>> $B-!(BS2Dao$B$K$F!"Ns%5%$%:$r$"$k0lDj0J>e$K$9$k$[E-MAIL ADDRESS DELETED]=$,Mn$A$k!"(B
>> $BKt$O!"(BBean($B%F!<%V%k(B)$B$N%5%$%:!&Ns?t$r$"$k0lDj0J>e$K$9$k$[E-MAIL ADDRESS DELETED]=$,Mn$A$kEy!"2?$[E-MAIL ADDRESS DELETED]=$K$D$$$F$N>pJs$O$J$$$G$7$g$&$+!)!)(B
>
>S2Dao $B$+$I$&$+$K4X78$J$/!$%M%C%H%o!<%/$rDL$k%G!<%?$N(B
>$BE>AwNL$b%a%b%j$N>CHqNL$,A}$($k$N$G$3$N798~$O$"$j$^$9!%(B
>
>> $B-"$^$?!"(BBean($B%F!<%V%k(B)$BDj5A$rJQ$($:%Q%U%)!<%^%s%9$r8~>e$5$;$kJ}K!$K$D$$$F2?$+$4B8CN$G$O$J$$$G$7$g$&$+!)(B
>> S2Dao$B$N%P!<%8%g%s!"(BS2Dao$B$[E-MAIL ADDRESS DELETED]!"(BDriver$B!"$=$NB>$I$s$J>pJs$G$b9=$$$^$;$s$N$G!">pJs$rD:$1$?$i$H;W$$$^$9!#(B
>
>$B%Q%U%)!<%^%s%9$GLdBj$,$"$k$J$i!$$^$:$O%\%H%k%M%C%/$r(B
>$BC5$9$N$,4pK\$G$9!%>u67$,J,$+$i$J$1$l$PC/$b%"%I%P%$%9(B
>$B$G$-$J$$$H;W$$$^$9!%(B
>VusualVm $B$J$I$r;H$C$F%a%b%j$N>CHqNL$d;~4V$N(B
>$B$+$+$C$F$$$k%a%=%C%I$r3NG'$7$F$O$$$+$,$G$7$g$&$+!%(B
>$B$^$?!$(BJDBC API $B$rD>@\;H$C$?>l9g$HHf3S$9$k$H$+!%(B
$B%"%I%P%$%9$r$"$j$,$H$&$4$6$$$^$9!#(B
$BJ?9T$7$F%j%=!<%9$ND4::$b?J$a$F$*$j$^$9!#(B
SELECT$BJ8(B(select * )$B$b(BDB$B$bJQ99$;$:!"(BBean(setter/getter)$B$NDI2C$N$_$G(B
$[E-MAIL ADDRESS DELETED]=Dc2<$,5/$3$C$F$*$j$^$9$N$G!"(BS2Dao$B$N4QE@$+$i2?$+$o$+$k$3$H$,$J$$$+$H;W$$<ALd$5$;$FD:$$$F$*$j$^$9!#(B

>
>> >S2Dao $B$O(B select * $B!A(B $B$G$O$J$/!$(Bselect col1, col2, $B!A(B
>> >$B$H$$$&(B SQL $B$r<B9T$7$^$9!%(B
>> >$B$=$N$?$a!$(BBean $B$N%W%m%Q%F%#$r85$KLa$;$P<hF@$9$k(B
>> >$B%+%i%`$N?t$b%G!<%?$NE>AwNL$b85$KLa$j$^$9!%(B
>> $B30It(BSQL$B$K!V(Bselect * $B!A!W$H5-=R$7$F$*$j$^$9!#(B
>> $B$3$N>l9g$b!"(BS2Dao$B$G!V(Bselect col1, col2$B!W$KJQ$o$k(B
>> $B$H8@$&G'<1$G9g$C$F$$$^$9$G$7$g$&$+!)(B
>
>SQL $B%U%!%$%k$r;H$C$F$$$k$J$i$=$N(B SQL $B$NDL$j$K(B
>$B<B9T$5$l$^$9!%(B
$BN;2r$7$^$7$?!#$"$j$,$H$&$4$6$$$^$9!#(B