IRC logs of #tryton for Thursday, 2011-05-05

chat.freenode.net #tryton log beginning Thu May 5 00:00:03 CEST 2011
-!- GasbaKid(~GasbaKid@41.96.69.242) has joined #tryton00:02
-!- vladimirek(~vladimire@adsl-dyn88.91-127-104.t-com.sk) has joined #tryton00:16
-!- ikks(~ikks@186.83.198.61) has joined #tryton00:53
-!- zodman(~andres-va@fixed-203-7-69.iusacell.net) has joined #tryton00:53
-!- zodman(~andres-va@foresight/developer/zodman) has joined #tryton00:53
-!- GasbaKid(~GasbaKid@41.96.69.242) has joined #tryton01:23
-!- curlynostrilll(~curlynost@96.57.28.108) has joined #tryton02:21
-!- effenber1(~chlu@pD9E9B88C.dip.t-dialin.net) has joined #tryton04:15
-!- alimon(~alimon@187.156.35.238) has joined #tryton04:36
-!- yangoon(~mathiasb@p549F2E74.dip.t-dialin.net) has joined #tryton05:19
-!- alimon(~alimon@187.156.35.238) has joined #tryton06:07
-!- elbenfreund(~elbenfreu@p54B94224.dip.t-dialin.net) has joined #tryton06:21
-!- nicoe(~nicoe@63.3-247-81.adsl-dyn.isp.belgacom.be) has joined #tryton07:05
-!- nicoe_(~nicoe@63.3-247-81.adsl-dyn.isp.belgacom.be) has joined #tryton07:25
-!- nicoe(~nicoe@63.3-247-81.adsl-dyn.isp.belgacom.be) has joined #tryton07:29
-!- nicoe(~nicoe@63.3-247-81.adsl-dyn.isp.belgacom.be) has joined #tryton07:32
-!- nicoe(~nicoe@63.3-247-81.adsl-dyn.isp.belgacom.be) has joined #tryton07:52
-!- nicoe(~nicoe@63.3-247-81.adsl-dyn.isp.belgacom.be) has joined #tryton08:04
-!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton08:23
-!- sharkcz(~sharkcz@2001:15c0:6747:160:250:43ff:fe3c:3b5d) has joined #tryton08:46
-!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton08:50
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton09:08
-!- pjstevns(~pjstevns@a83-163-46-103.adsl.xs4all.nl) has joined #tryton09:21
-!- blast_hardcheese(~blast_har@cpe-98-154-59-208.socal.res.rr.com) has joined #tryton09:23
-!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton09:58
-!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton10:00
-!- bechamel(~user@cismwks02-virtual1.cism.ucl.ac.be) has joined #tryton10:04
-!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton10:06
-!- nicoe(~nicoe@ced.homedns.org) has joined #tryton10:17
-!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton10:39
-!- gavinf(~gavinf@196-215-11-70.dynamic.isadsl.co.za) has joined #tryton10:46
-!- gavinf(~gavinf@196-215-11-70.dynamic.isadsl.co.za) has left #tryton10:48
-!- heffer(~felix@fedora/heffer) has joined #tryton12:05
-!- many(many@shell.ukeer.de) has joined #tryton12:06
-!- elbenfreund1(~elbenfreu@p54B94224.dip.t-dialin.net) has joined #tryton12:52
-!- rhubner(~rhubner@187.112.228.23) has joined #tryton14:05
rhubner\j #gsoc-br14:06
-!- rhubner(~rhubner@187.112.228.23) has left #tryton14:06
-!- rhubner(~rhubner@187.112.228.23) has joined #tryton14:07
-!- alimon(~alimon@189.154.38.109) has joined #tryton15:11
-!- rhubner(~rhubner@187.112.228.23) has left #tryton15:43
-!- gavinf(~gavinf@196-215-11-70.dynamic.isadsl.co.za) has joined #tryton16:05
gavinfI have recently upgraded to 2.0 and when I try to save a new invoice I get the error 'Invalid Form' and cannot save. Any tips?16:09
yangoongavinf: some required field is missing16:17
yangoongavinf: did you update the database16:18
yangoon?16:18
gavinfyes I ran the database update and did the module updates in the client16:18
gavinfand I completed all required fields that I can see (mauve colour)16:19
gavinfwhere does tryton log these days? my /var/log/trytond.log hasn't been written to for 6 months16:20
cedkgavinf: it is configured in trytond.conf16:30
-!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton16:35
-!- gremly(~gremly@200.106.202.91) has joined #tryton17:34
-!- elbenfreund2(~elbenfreu@p54B9379A.dip.t-dialin.net) has joined #tryton17:37
-!- sharoon(~sharoon@173-9-190-190-miami.txt.hfc.comcastbusiness.net) has joined #tryton17:51
-!- elbenfreund(~elbenfreu@p54B9379A.dip.t-dialin.net) has joined #tryton17:55
-!- FWiesing(~franz@mail.tryton.at) has joined #tryton18:36
-!- alimon(~alimon@187.156.76.195) has joined #tryton18:55
-!- gremly(~gremly@200.106.202.91) has joined #tryton18:59
-!- vladimirek(~vladimire@bband-dyn166.178-41-220.t-com.sk) has joined #tryton19:48
-!- nicoe(~nicoe@63.3-247-81.adsl-dyn.isp.belgacom.be) has joined #tryton20:04
-!- FWiesing(~franz@mail.tryton.at) has left #tryton20:06
-!- nicoe(~nicoe@63.3-247-81.adsl-dyn.isp.belgacom.be) has joined #tryton20:18
-!- nicoe(~nicoe@63.3-247-81.adsl-dyn.isp.belgacom.be) has joined #tryton20:21
sharooncedk: doing some experiments here on mptt20:29
cedksharoon: well20:31
sharooncedk: an interesting result is that RECURSIVE search is orders of magnitude faster than MPTT in both read and write20:31
sharooncedk: s/RECURSIVE search/RECURSIVE CTE query http://www.postgresql.org/docs/9.0/static/queries-with.html20:31
cedksharoon: don'T understand20:31
cedksharoon: that is not possible20:32
sharooncedk: i got the idea from here: http://justcramer.com/2010/05/30/scaling-threaded-comments-on-django-at-disqus/20:32
sharooncedk: let me paste what i did onto a pastie20:33
sharooncedk: http://paste.pocoo.org/show/383572/20:37
sharooncedk: it is almost a replica of what i did, some model changes etc to anonymise20:37
cedksharoon: what is the depth of the tree?20:39
sharooncedk: and the result is 9.5997259616851807 s for t1 (MPTT) and 2.6397891044616699 for Recursive20:39
sharooncedk: the depth is 9 and descendant count is 58020:39
cedksharoon: have you index on parent_left and parent_right?20:40
sharoonyep20:40
cedksharoon: could you try: http://paste.pocoo.org/show/383579/20:42
sharooncedk: trying20:43
cedksharoon: also with the search you have the overload of the rules, the prefetching20:46
sharooncedk: its the ir.rules :(20:49
cedksharoon: ???20:49
sharooncedk: the result is 2.9281599521636963 and 2.735212802886962920:49
yangooncedk: I get 500 Server Error on http://codereview.tryton.org/29001/publish, but I can view the issue20:49
sharooncedk: MPTT and Recursive respectively20:50
cedkyangoon: it works here20:50
cedksharoon: with my version?20:50
sharooncedk: yes20:50
cedk<:-~20:51
cedksharoon: now you should try with bigger depth20:51
sharooncedk: ok20:52
cedksharoon: but I'm pretty sure that recursive SQL query will be slower20:54
cedksharoon: MTTP must be O(1) on the depth20:55
cedksharoon: and Recursive SQL should be O(n)20:56
sharooncedk: yes, it is O(1) and recursive is O(n)20:56
cedksharoon: but of course Recursive SQL is fast because pg is well developed :-)20:56
sharooncedk: i checked the raw speeds to bypass ordering and ir rules and domain construction and its faster than recursion20:57
sharooncedk: yeh, I am amazed by the speed of recursive query20:57
cedksharoon: by the way, in ModelSQL the child_of search use SQL query directly and not a search20:57
cedksharoon: I guess with the amount of data you got, the row are in memory20:58
sharooncedk: any suggestion on how to optimise a query if categories are hierarchial like now, but products has a m2m relation to category ?20:59
cedksharoon: what is really bad with child_of without MPTT is all the data tranfered between pg and trytond20:59
cedksharoon: but what do you want to query?21:00
sharooncedk: products under a category (including all its descendants)21:01
cedksharoon: SQL query with a join and MPTT where clause21:02
sharooncedk: ok21:03
-!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton21:06
cedksharoon: something like http://paste.pocoo.org/show/383598/21:06
cedkACTION happy MPTT is still faster21:06
cedksharoon: but will you still try to improve the MPTT update?21:07
sharooncedk: but write on MPTT still sucks!! you saw the problem with concurrent tree update21:07
sharooncedk: yes, since nothing beats MPTT in read, I will be working on improving MPTT write21:07
cedksharoon: you make a lot much more search on tree than write/create21:08
sharooncedk: yes21:09
cedksharoon: perhaps have a look at https://github.com/django-mptt/django-mptt/21:12
cedksharoon: but github seems down right now21:13
cedksharoon: in django-mptt there is a big SQL query that seems to do the job21:18
cedksharoon: it is in managers.py#_inter_tree_move_and_close_gap21:19
sharooncedk: reading21:19
cedkACTION bbl21:20
-!- gremly(~gremly@200.106.202.91) has joined #tryton21:25
yangooncedk: I get the 500, when 'Send mail' is activated on Publish + Mail Draft Comments21:38
-!- elbenfreund1(~elbenfreu@p54B9379A.dip.t-dialin.net) has joined #tryton21:56
-!- bechamel(~user@host-85-201-144-79.brutele.be) has joined #tryton22:09
-!- curlynostrill(~curlynost@96.57.28.108) has joined #tryton22:11
-!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton22:19
-!- plantian(~ian@c-67-169-72-36.hsd1.ca.comcast.net) has left #tryton22:42
-!- enlightx(~enlightx@78.5.218.47) has joined #tryton23:09
sharooncedk: we already have this feature right ? https://bugs.launchpad.net/openobject-client/+bug/77801623:21
cedksharoon: yes23:52
cedksharoon: you should have a look at23:54
cedkhttps://github.com/django-mptt/django-mptt/blob/master/mptt/managers.py#L41923:54
cedkhttps://github.com/django-mptt/django-mptt/blob/master/mptt/managers.py#L67923:55

Generated by irclog2html.py 2.11.0 by Marius Gedminas - find it at mg.pov.lt!