Database Reference
In-Depth Information
',6.B5($'6 ',6.B5($'6B3(5B(; %8))(5B*(76 %8))(5B*(76B3(5B(;
',5(&7B:5,7(6 ',5(&7B:5,7(6B3(5B(;
3$56(B&$//6 (;(&87,216 52:6B352&(66('
&38(ODSVHG7LPHVHFWRWDO SHUH[
3/64/([HF7LPHVHFWRWDO SHUH[
-$9$([HF7LPHVHFWRWDO SHUH[
$SSOLFDWLRQ:DLW7LPHVHFWRWDO SHUH[
&RQFXUUHQF\:DLW7LPHVHFWRWDO SHUH[
&OXVWHU:DLW7LPHVHFWRWDO SHUH[
8VHU,2:DLW7LPHVHFWRWDO SHUH[
([DFW6LJQDWXUH )RUFH6LJQDWXUH
2XWOLQH&DWHJRU\ '()$8/7
6HUYLFH;;;
0RGXOH-'%&7KLQ&OLHQW
86(5 ;;;;;;6&+(0$ ;;;;;;237,0,=(5B02'( $//B52:6
237,0,=(5B(19B+$6+B9$/8( 86(56B23(1 86(56B(;(&
64/B,' !XVM]IWYF$''5(66 !&)'+$6+B9$/8( !
2/'B+$6+B9$/8( !&+,/'B180%(5 !
6(/(&7,1'(;GVGVBFRQYHUVDWLRQ'6B).GVFRQYBLGGVFRQYBW\SHGVFLNH\
GVGRPDLQBUHIGVSURFHVVBLGGVUHYLVLRQBWDJGVSURFHVVBJXLGGVRSHUDWLRQBQDPH
GVVXEVFULEHUBLGGVVHUYLFHBQDPHGVVXEVFULSWLRQBGDWHGVVWDWHGVSU
RSHUWLHV)520GOYBVXEVFULSWLRQGV6(/(&7',67,1&7,1'(;GVGVBFRQYHUVDWLRQ'6B).
GVFLNH\)520GOYBVXEVFULSWLRQGV:+(5(GVFRQYBLG $1'GVVWDWH 6<6B%B$1'
GVGRPDLQBUHI XQUHVROYHGBVXEVFULSWLRQV:+(5(GVFLNH\ XQUHVROYHGBVXEVFULSWLRQVFLNH\
$1'GVVWDWH 6<6B%B$1'127(;,6766(/(&7,1'(;GVGVBFRQYHUVDWLRQ'6B).
,1'(;GVGVBFRQYHUVDWLRQ'6B).6<6B%B)520GOYBVXEVFULSWLRQGV:+(5(GVVWDWH
6<6B%B$1'GVFLNH\ GVFLNH\$
1'GVGRPDLQBUHI GVGRPDLQBUHI$1'GVGRPDLQBUHI )2583'$7(2)
GVVXEVFULEHUBLG12:$,7
([HFXWLRQ3ODQ3ODQ+DVK9DOXH
6(/(&767$7(0(172SWLPL]HU +,17$//B52:6&RVW
)2583'$7(%LQG3HHNLQJXVHG
1(67('/2236$17,&RVW &DUG %\WHV &38B&RVW
,2B&RVW 7LPH
1(67('/2236&RVW &DUG %\WHV &38B&RVW ,2B&RVW
7LPH
9,(:&RVW &DUG %\WHV &38B&RVW ,2B&RVW 7LPH
625781,48(&RVW &DUG %\WHV &38B&RVW
,2B&RVW 7LPH :$6WDWV3ROLF\$872/DVW0HP.2SW0HP.3DVV0HP.
2SW0XOW
7$%/($&&(66%<,1'(;52:,'2)'/9B68%6&5,37,21&RVW &DUG
%\WHV &38B&RVW ,2B&RVW 7LPH
,1'(;5$1*(6&$12)'6B&219(56$7,21&RVW &DUG
&38B&RVW ,2B&RVW 7LPH
7$%/($&&(66%<,1'(;52:,'2)'/9B68%6&5,37,21&RVW &DUG %\WHV
&38B&RVW ,2B&RVW 7LPH
,1'(;5$1*(6&$12)'6B).&RVW &DUG &38B&RVW ,2B&RVW
7LPH
In diesem Fall war das Performanz-Problem so gravierend, dass ich mit dieser empirischen
Lösungversuchte,dieZeitfürdieAnalysezuersparen.
Fazit
• SQL-TuningmitdenParametereinstellungenaufderSession-Ebeneisteinesehref-
fektive Tuning-Methode,
• ineinerNot-SituationkönnendieempirischenLösungenvielZeitersparen.Fürsol-
cheLösungenbrauchtmanabereinegewisseErfahrung.
