[Moscow.pm] ÔÔÔÔ [ ÁÍMoscow.pm] òÁÚÍÙÛÌÅÎÉÑ ÎÁ ÔÅÍÕ ORM É ×ÏÏÂÝÅÃËÕ ÒÁÂÏÅÌÍÔÙ Í Å Á.ÌÁ uuoklfifffffffyifufffffffffuuufffufcfhvfghcgfufiffffuhhppoooplmkffÓ âä

[áÎÄÒÅÊ ëÏÓÔÅÎËÏ]

÷ÏÔ ÉÍÅÎÎÏ!

2011/10/28 Ivan Panchenko <ivan ÎÁ stack.net>

>
> Lolllb
> Fpkppbubbp
>
> íÉÈÁÉÌ ûÏÇÉÎ <mshogin ÎÁ gmail.com> ÎÁÐÉÓÁÌ(Á):
>
> >>
> >> > íÄÁ, ÄÏÌÇÁÑ ÄÉÓËÕÓÓÉÑ.
> >> >
> >> > ORM - ÚÌÏ!
> >> >
> >> > þÔÏ ÔÁËÏÅ SQL ( × ÐÒÏÓÔÏÍ ÏÐÒÅÄÅÌÅÎÉÉ ) - ÜÔÏ ÔÏ ÞÔÏ ÍÙ ÈÏÔÉÍ ÐÏÌÕÞÉÔØ
> É
> >> > ðõôø ÐÏÌÕÞÅÎÉÑ ÄÁÎÎÙÈ.
> >> > ðÒÉ ÉÓÐÏÌØÚÏ×ÁÎÉÉ ORM É ËÏÎÓÔÒÕËÔÏÒÏ× ÚÁÐÒÏÓÏ×, ÍÙ ÎÅ ÞÅÒÔÁ ÎÅ ÚÎÁÅÍ
> >> ËÁËÉÍ
> >> > ÐÕÔÅÍ ÍÙ ÐÏÌÕÞÁÅÍ ÄÁÎÎÙÅ, Á ÜÔÏ ÓÁÍÏÅ ÇÌÁ×ÎÏÅ.
> >> > ëÁË ÏÐÔÉÍÉÚÉÒÏ×ÁÔØ ÚÁÐÒÏÓÙ? ëÁË ÚÁËÒÅÐÌÑÔØ ÐÌÁÎÙ ×ÙÐÏÌÎÅÎÉÑ?
> >> > ÷ÅÄØ × ËÁËÏÍ ÔÏ ÓÌÕÞÁÅ ÌÕÞÛÅ ÉÓÐÏÌØÚÏ×ÁÔØ HASH JOIN, Á × ËÁËÏÍ ÔÏ
> NESTED
> >> > LOOP.
> >> >
> >> > äÁÖÅ ÂÁÎÁÌØÎÁÑ ÆÉÌØÔÒÁÃÉÑ ÄÁÎÎÙÈ ÍÏÖÅÔ ÉÄÔÉ ÎÅÓËÏÌØËÉÍÉ ÒÁÚÌÉÞÎÙÍÉ
> >> ÐÕÔÑÍÉ:
> >> >  - table full scan
> >> >  - index range scan + table access by rowid
> >> >  - index range scan
> >> >  - index full scan
> >> >
> >> > ëÁË ×ÓÅÍ ÜÔÉÍ ÕÐÒÁ×ÌÑÔØ?
> >>
> >> æÉÛËÁ ÚÄÅÓØ × ÔÏÍ ÞÔÏ ÔÁËÏÊ ÍÉËÒÏÓËÏÐ ÎÕÖÅÎ ÎÁ 1 ÉÚ 100 ÚÁÐÒÏÓÏ×. è×ÁÔÁÊ
> >> ÇÏÌÙÊ $dbh ÉÚ DBIC É ÄÅÌÁÊ ÞÔÏ ÈÏÞÅÛ. ÷ÅÄØ ÎÉÇÄÅ ÎÅ ÓËÁÚÁÎÏ ÞÔÏ ÒÁÚ DBIC
> >> ÔÁË ×ÓÅÇÄÁ DBIC. îÁÄÏ ×ÓÅ ÔÁËÉ ÕÍÅÔØ ÓÏÏÂÒÁÚÉÔØ ËÏÇÄÁ ÐÏÒÁ ÐÏÌÏÖÉÔØ
> ÍÏÌÏÔÏË
> >> É ×ÚÑÔØ ÏÔ×ÅÒÔËÕ :)
> >>
> >
> >èÅÈ, ÎÅÔ, Õ ÎÁÓ ÎÅ ÔÁË. úÁÐÒÏÓÙ ÏÐÔÉÍÉÚÉÒÕÀÔÓÑ ÐÅÒÅÄ ÉÓÐÏÌØÚÏ×ÁÎÉÅÍ ×
> ËÏÄÅ.
> >+ ×ÙÓÔÁ×ÌÑÀÔÓÑ ÈÉÎÔÙ ÄÌÑ ÂÙÓÔÒÏÇÏ ×ÙÑ×ÌÅÎÉÑ ÔÏÒÍÏÚÎÙÈ ÚÁÐÒÏÓÏ×.
> >
> >
> >
> >--
> >ó Õ×ÁÖÅÎÉÅÍ
> >íÉÈÁÉÌ ûÏÇÉÎ.
> >Tel: +7 915 0311328
> >ICQ: 266776394
> >
> >--
> >Moscow.pm mailing list
> >moscow-pm ÎÁ pm.org | http://moscow.pm.org
> --
> Moscow.pm mailing list
> moscow-pm ÎÁ pm.org | http://moscow.pm.org
>
----------- ÓÌÅÄÕÝÁÑ ÞÁÓÔØ -----------
÷ÌÏÖÅÎÉÅ × ÆÏÒÍÁÔÅ HTML ÂÙÌÏ ÉÚ×ÌÅÞÅÎÏ…
URL: <http://mail.pm.org/pipermail/moscow-pm/attachments/20111028/40f1d89a/attachment.html>