| 26. 06. 2010 22:25 (Zmenené: 26. 06. 2010 23:18)

Tunnelers

Niektorí z vás si možno pamätajú starú, klasickú hru menom Tunneler. Dvaja hráči sedeli za 286kou, ovládali svoj tank v podzemí a snažili sa toho druh...

Čítať celý článok

Ladislav Benc | Zobrazení: 236 | Reakcií: 4 | Skóre: 0.6

| 22. 12. 2009 21:16

Dokonceny blog.: Male zhrnutie

Tak, blizi sa odovzdavanie blogu. Snad uz je vo finalnej podobe....

Čítať celý článok

Ladislav Benc | Zobrazení: 190 | Reakcií: 4 | Skóre: 0.7

| 19. 12. 2009 14:18

Prispevok na testovanie funkcionality blogu: Podnadpis

Testujem....

Čítať celý článok

Ladislav Benc | Zobrazení: 141 | Reakcií: 10 | Skóre: 0.2

| 08. 10. 2009 19:32 (Zmenené: 26. 06. 2010 23:30)

Inteligentné centrum pre nápravu nebezpečných delikventov

OSPRAVEDLNENIE: Post som písal počas robenia predmetu o Web dizajne, kedy je blog v špeciálnom móde - a teraz v ňom nefunguje ani klasické formátovani...

Čítať celý článok

Ladislav Benc | Zobrazení: 448 | Reakcií: 0 | Skóre: 0.9

No.	query	time
1	collection("weblog")/user[info/nick="laci"]/@ID/normalize-space()	0.0199069976807
2	let $all := collection("weblog")/user/blog/post[@status="published"][contains("sk",@lang)][../../@ID="u386"], $list := subsequence( for $i in $all order by ( xs:integer($i/date/@timestamp) ) descending return $i,1,20), $last := count($all), $posts:= (for $current in $list let $user := $current/ancestor::user return <post>{$current/@ID}{$current/@lang}{$current/@accessCount} <user>{$user/@ID}{$user/@type} {$user/info/nick} {$user/info/realName} </user> {$current/*} </post> ) return <module name="Articles"><newPosts last="{$last}" end="20" start="1">{$posts}</newPosts></module>	0.175354957581
3	let $all := collection("weblog")/user/blog/post[@status="published"][contains("sk",@lang)][../../@ID="u386"]//comment, $last := subsequence( for $i in $all order by ( xs:integer($i/date/@timestamp) ) ascending return $i,count($all),1) return <post>{$last/ancestor::post/@*} {$last/ancestor::post/title} {$last/ancestor::post/subtitle} {$last} </post>	0.093761920929
4	collection("weblog")/user[@ID="u386"]/info	0.0167000293732
5	collection("weblog")/user[@ID="u386"]/blog/title	0.0162739753723
6	let $bg := collection("weblog")/user[@ID="u386"]/blog/background, $color := collection("weblog")/user[@ID="u386"]/blog/colorscheme return <customizations> <blogBackground>{$bg}</blogBackground> <colorScheme>{$color}</colorScheme> </customizations>	0.0104968547821
*	total time	0.332494735718

No.

query

time

collection("weblog")/user[info/nick="laci"]/@ID/normalize-space()

0.0199069976807

let $all := collection("weblog")/user/blog/post[@status="published"][contains("sk",@lang)][../../@ID="u386"], $list := subsequence( for $i in $all order by ( xs:integer($i/date/@timestamp) ) descending return $i,1,20), $last := count($all), $posts:= (for $current in $list let $user := $current/ancestor::user return <post>{$current/@ID}{$current/@lang}{$current/@accessCount} <user>{$user/@ID}{$user/@type} {$user/info/nick} {$user/info/realName} </user> {$current/*} </post> ) return <module name="Articles"><newPosts last="{$last}" end="20" start="1">{$posts}</newPosts></module>

0.175354957581

let $all := collection("weblog")/user/blog/post[@status="published"][contains("sk",@lang)][../../@ID="u386"]//comment, $last := subsequence( for $i in $all order by ( xs:integer($i/date/@timestamp) ) ascending return $i,count($all),1) return <post>{$last/ancestor::post/@*} {$last/ancestor::post/title} {$last/ancestor::post/subtitle} {$last} </post>

0.093761920929

collection("weblog")/user[@ID="u386"]/info

0.0167000293732

collection("weblog")/user[@ID="u386"]/blog/title

0.0162739753723

let $bg := collection("weblog")/user[@ID="u386"]/blog/background, $color := collection("weblog")/user[@ID="u386"]/blog/colorscheme return <customizations> <blogBackground>{$bg}</blogBackground> <colorScheme>{$color}</colorScheme> </customizations>

0.0104968547821

total time

0.332494735718

blog.matfyz.sk

Blog

Tunnelers

Dokonceny blog.: Male zhrnutie

Prispevok na testovanie funkcionality blogu: Podnadpis

Inteligentné centrum pre nápravu nebezpečných delikventov

O autorovi

Diskusia