| chat.freenode.net #tryton log beginning Thu May 5 00:00:03 CEST 2011 | ||
| 2011-05-05 00:02 -!- GasbaKid(~GasbaKid@41.96.69.242) has joined #tryton | ||
| 2011-05-05 00:16 -!- vladimirek(~vladimire@adsl-dyn88.91-127-104.t-com.sk) has joined #tryton | ||
| 2011-05-05 00:53 -!- ikks(~ikks@186.83.198.61) has joined #tryton | ||
| 2011-05-05 00:53 -!- zodman(~andres-va@fixed-203-7-69.iusacell.net) has joined #tryton | ||
| 2011-05-05 00:53 -!- zodman(~andres-va@foresight/developer/zodman) has joined #tryton | ||
| 2011-05-05 01:23 -!- GasbaKid(~GasbaKid@41.96.69.242) has joined #tryton | ||
| 2011-05-05 02:21 -!- curlynostrilll(~curlynost@96.57.28.108) has joined #tryton | ||
| 2011-05-05 04:15 -!- effenber1(~chlu@pD9E9B88C.dip.t-dialin.net) has joined #tryton | ||
| 2011-05-05 04:36 -!- alimon(~alimon@187.156.35.238) has joined #tryton | ||
| 2011-05-05 05:19 -!- yangoon(~mathiasb@p549F2E74.dip.t-dialin.net) has joined #tryton | ||
| 2011-05-05 06:07 -!- alimon(~alimon@187.156.35.238) has joined #tryton | ||
| 2011-05-05 06:21 -!- elbenfreund(~elbenfreu@p54B94224.dip.t-dialin.net) has joined #tryton | ||
| 2011-05-05 07:05 -!- nicoe(~nicoe@63.3-247-81.adsl-dyn.isp.belgacom.be) has joined #tryton | ||
| 2011-05-05 07:25 -!- nicoe_(~nicoe@63.3-247-81.adsl-dyn.isp.belgacom.be) has joined #tryton | ||
| 2011-05-05 07:29 -!- nicoe(~nicoe@63.3-247-81.adsl-dyn.isp.belgacom.be) has joined #tryton | ||
| 2011-05-05 07:32 -!- nicoe(~nicoe@63.3-247-81.adsl-dyn.isp.belgacom.be) has joined #tryton | ||
| 2011-05-05 07:52 -!- nicoe(~nicoe@63.3-247-81.adsl-dyn.isp.belgacom.be) has joined #tryton | ||
| 2011-05-05 08:04 -!- nicoe(~nicoe@63.3-247-81.adsl-dyn.isp.belgacom.be) has joined #tryton | ||
| 2011-05-05 08:23 -!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton | ||
| 2011-05-05 08:46 -!- sharkcz(~sharkcz@2001:15c0:6747:160:250:43ff:fe3c:3b5d) has joined #tryton | ||
| 2011-05-05 08:50 -!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton | ||
| 2011-05-05 09:08 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | ||
| 2011-05-05 09:21 -!- pjstevns(~pjstevns@a83-163-46-103.adsl.xs4all.nl) has joined #tryton | ||
| 2011-05-05 09:23 -!- blast_hardcheese(~blast_har@cpe-98-154-59-208.socal.res.rr.com) has joined #tryton | ||
| 2011-05-05 09:58 -!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton | ||
| 2011-05-05 10:00 -!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton | ||
| 2011-05-05 10:04 -!- bechamel(~user@cismwks02-virtual1.cism.ucl.ac.be) has joined #tryton | ||
| 2011-05-05 10:06 -!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton | ||
| 2011-05-05 10:17 -!- nicoe(~nicoe@ced.homedns.org) has joined #tryton | ||
| 2011-05-05 10:39 -!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton | ||
| 2011-05-05 10:46 -!- gavinf(~gavinf@196-215-11-70.dynamic.isadsl.co.za) has joined #tryton | ||
| 2011-05-05 10:48 -!- gavinf(~gavinf@196-215-11-70.dynamic.isadsl.co.za) has left #tryton | ||
| 2011-05-05 12:05 -!- heffer(~felix@fedora/heffer) has joined #tryton | ||
| 2011-05-05 12:06 -!- many(many@shell.ukeer.de) has joined #tryton | ||
| 2011-05-05 12:52 -!- elbenfreund1(~elbenfreu@p54B94224.dip.t-dialin.net) has joined #tryton | ||
| 2011-05-05 14:05 -!- rhubner(~rhubner@187.112.228.23) has joined #tryton | ||
| 2011-05-05 14:06 <rhubner> \j #gsoc-br | ||
| 2011-05-05 14:06 -!- rhubner(~rhubner@187.112.228.23) has left #tryton | ||
| 2011-05-05 14:07 -!- rhubner(~rhubner@187.112.228.23) has joined #tryton | ||
| 2011-05-05 15:11 -!- alimon(~alimon@189.154.38.109) has joined #tryton | ||
| 2011-05-05 15:43 -!- rhubner(~rhubner@187.112.228.23) has left #tryton | ||
| 2011-05-05 16:05 -!- gavinf(~gavinf@196-215-11-70.dynamic.isadsl.co.za) has joined #tryton | ||
| 2011-05-05 16:09 <gavinf> I 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? | ||
| 2011-05-05 16:17 <yangoon> gavinf: some required field is missing | ||
| 2011-05-05 16:18 <yangoon> gavinf: did you update the database | ||
| 2011-05-05 16:18 <yangoon> ? | ||
| 2011-05-05 16:18 <gavinf> yes I ran the database update and did the module updates in the client | ||
| 2011-05-05 16:19 <gavinf> and I completed all required fields that I can see (mauve colour) | ||
| 2011-05-05 16:20 <gavinf> where does tryton log these days? my /var/log/trytond.log hasn't been written to for 6 months | ||
| 2011-05-05 16:30 <cedk> gavinf: it is configured in trytond.conf | ||
| 2011-05-05 16:35 -!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton | ||
| 2011-05-05 17:34 -!- gremly(~gremly@200.106.202.91) has joined #tryton | ||
| 2011-05-05 17:37 -!- elbenfreund2(~elbenfreu@p54B9379A.dip.t-dialin.net) has joined #tryton | ||
| 2011-05-05 17:51 -!- sharoon(~sharoon@173-9-190-190-miami.txt.hfc.comcastbusiness.net) has joined #tryton | ||
| 2011-05-05 17:55 -!- elbenfreund(~elbenfreu@p54B9379A.dip.t-dialin.net) has joined #tryton | ||
| 2011-05-05 18:36 -!- FWiesing(~franz@mail.tryton.at) has joined #tryton | ||
| 2011-05-05 18:55 -!- alimon(~alimon@187.156.76.195) has joined #tryton | ||
| 2011-05-05 18:59 -!- gremly(~gremly@200.106.202.91) has joined #tryton | ||
| 2011-05-05 19:48 -!- vladimirek(~vladimire@bband-dyn166.178-41-220.t-com.sk) has joined #tryton | ||
| 2011-05-05 20:04 -!- nicoe(~nicoe@63.3-247-81.adsl-dyn.isp.belgacom.be) has joined #tryton | ||
| 2011-05-05 20:06 -!- FWiesing(~franz@mail.tryton.at) has left #tryton | ||
| 2011-05-05 20:18 -!- nicoe(~nicoe@63.3-247-81.adsl-dyn.isp.belgacom.be) has joined #tryton | ||
| 2011-05-05 20:21 -!- nicoe(~nicoe@63.3-247-81.adsl-dyn.isp.belgacom.be) has joined #tryton | ||
| 2011-05-05 20:29 <sharoon> cedk: doing some experiments here on mptt | ||
| 2011-05-05 20:31 <cedk> sharoon: well | ||
| 2011-05-05 20:31 <sharoon> cedk: an interesting result is that RECURSIVE search is orders of magnitude faster than MPTT in both read and write | ||
| 2011-05-05 20:31 <sharoon> cedk: s/RECURSIVE search/RECURSIVE CTE query http://www.postgresql.org/docs/9.0/static/queries-with.html | ||
| 2011-05-05 20:31 <cedk> sharoon: don'T understand | ||
| 2011-05-05 20:32 <cedk> sharoon: that is not possible | ||
| 2011-05-05 20:32 <sharoon> cedk: i got the idea from here: http://justcramer.com/2010/05/30/scaling-threaded-comments-on-django-at-disqus/ | ||
| 2011-05-05 20:33 <sharoon> cedk: let me paste what i did onto a pastie | ||
| 2011-05-05 20:37 <sharoon> cedk: http://paste.pocoo.org/show/383572/ | ||
| 2011-05-05 20:37 <sharoon> cedk: it is almost a replica of what i did, some model changes etc to anonymise | ||
| 2011-05-05 20:39 <cedk> sharoon: what is the depth of the tree? | ||
| 2011-05-05 20:39 <sharoon> cedk: and the result is 9.5997259616851807 s for t1 (MPTT) and 2.6397891044616699 for Recursive | ||
| 2011-05-05 20:39 <sharoon> cedk: the depth is 9 and descendant count is 580 | ||
| 2011-05-05 20:40 <cedk> sharoon: have you index on parent_left and parent_right? | ||
| 2011-05-05 20:40 <sharoon> yep | ||
| 2011-05-05 20:42 <cedk> sharoon: could you try: http://paste.pocoo.org/show/383579/ | ||
| 2011-05-05 20:43 <sharoon> cedk: trying | ||
| 2011-05-05 20:46 <cedk> sharoon: also with the search you have the overload of the rules, the prefetching | ||
| 2011-05-05 20:49 <sharoon> cedk: its the ir.rules :( | ||
| 2011-05-05 20:49 <cedk> sharoon: ??? | ||
| 2011-05-05 20:49 <sharoon> cedk: the result is 2.9281599521636963 and 2.7352128028869629 | ||
| 2011-05-05 20:49 <yangoon> cedk: I get 500 Server Error on http://codereview.tryton.org/29001/publish, but I can view the issue | ||
| 2011-05-05 20:50 <sharoon> cedk: MPTT and Recursive respectively | ||
| 2011-05-05 20:50 <cedk> yangoon: it works here | ||
| 2011-05-05 20:50 <cedk> sharoon: with my version? | ||
| 2011-05-05 20:50 <sharoon> cedk: yes | ||
| 2011-05-05 20:51 <cedk> <:-~ | ||
| 2011-05-05 20:51 <cedk> sharoon: now you should try with bigger depth | ||
| 2011-05-05 20:52 <sharoon> cedk: ok | ||
| 2011-05-05 20:54 <cedk> sharoon: but I'm pretty sure that recursive SQL query will be slower | ||
| 2011-05-05 20:55 <cedk> sharoon: MTTP must be O(1) on the depth | ||
| 2011-05-05 20:56 <cedk> sharoon: and Recursive SQL should be O(n) | ||
| 2011-05-05 20:56 <sharoon> cedk: yes, it is O(1) and recursive is O(n) | ||
| 2011-05-05 20:56 <cedk> sharoon: but of course Recursive SQL is fast because pg is well developed :-) | ||
| 2011-05-05 20:57 <sharoon> cedk: i checked the raw speeds to bypass ordering and ir rules and domain construction and its faster than recursion | ||
| 2011-05-05 20:57 <sharoon> cedk: yeh, I am amazed by the speed of recursive query | ||
| 2011-05-05 20:57 <cedk> sharoon: by the way, in ModelSQL the child_of search use SQL query directly and not a search | ||
| 2011-05-05 20:58 <cedk> sharoon: I guess with the amount of data you got, the row are in memory | ||
| 2011-05-05 20:59 <sharoon> cedk: any suggestion on how to optimise a query if categories are hierarchial like now, but products has a m2m relation to category ? | ||
| 2011-05-05 20:59 <cedk> sharoon: what is really bad with child_of without MPTT is all the data tranfered between pg and trytond | ||
| 2011-05-05 21:00 <cedk> sharoon: but what do you want to query? | ||
| 2011-05-05 21:01 <sharoon> cedk: products under a category (including all its descendants) | ||
| 2011-05-05 21:02 <cedk> sharoon: SQL query with a join and MPTT where clause | ||
| 2011-05-05 21:03 <sharoon> cedk: ok | ||
| 2011-05-05 21:06 -!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton | ||
| 2011-05-05 21:06 <cedk> sharoon: something like http://paste.pocoo.org/show/383598/ | ||
| 2011-05-05 21:06 <cedk> ACTION happy MPTT is still faster | ||
| 2011-05-05 21:07 <cedk> sharoon: but will you still try to improve the MPTT update? | ||
| 2011-05-05 21:07 <sharoon> cedk: but write on MPTT still sucks!! you saw the problem with concurrent tree update | ||
| 2011-05-05 21:07 <sharoon> cedk: yes, since nothing beats MPTT in read, I will be working on improving MPTT write | ||
| 2011-05-05 21:08 <cedk> sharoon: you make a lot much more search on tree than write/create | ||
| 2011-05-05 21:09 <sharoon> cedk: yes | ||
| 2011-05-05 21:12 <cedk> sharoon: perhaps have a look at https://github.com/django-mptt/django-mptt/ | ||
| 2011-05-05 21:13 <cedk> sharoon: but github seems down right now | ||
| 2011-05-05 21:18 <cedk> sharoon: in django-mptt there is a big SQL query that seems to do the job | ||
| 2011-05-05 21:19 <cedk> sharoon: it is in managers.py#_inter_tree_move_and_close_gap | ||
| 2011-05-05 21:19 <sharoon> cedk: reading | ||
| 2011-05-05 21:20 <cedk> ACTION bbl | ||
| 2011-05-05 21:25 -!- gremly(~gremly@200.106.202.91) has joined #tryton | ||
| 2011-05-05 21:38 <yangoon> cedk: I get the 500, when 'Send mail' is activated on Publish + Mail Draft Comments | ||
| 2011-05-05 21:56 -!- elbenfreund1(~elbenfreu@p54B9379A.dip.t-dialin.net) has joined #tryton | ||
| 2011-05-05 22:09 -!- bechamel(~user@host-85-201-144-79.brutele.be) has joined #tryton | ||
| 2011-05-05 22:11 -!- curlynostrill(~curlynost@96.57.28.108) has joined #tryton | ||
| 2011-05-05 22:19 -!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton | ||
| 2011-05-05 22:42 -!- plantian(~ian@c-67-169-72-36.hsd1.ca.comcast.net) has left #tryton | ||
| 2011-05-05 23:09 -!- enlightx(~enlightx@78.5.218.47) has joined #tryton | ||
| 2011-05-05 23:21 <sharoon> cedk: we already have this feature right ? https://bugs.launchpad.net/openobject-client/+bug/778016 | ||
| 2011-05-05 23:52 <cedk> sharoon: yes | ||
| 2011-05-05 23:54 <cedk> sharoon: you should have a look at | ||
| 2011-05-05 23:54 <cedk> https://github.com/django-mptt/django-mptt/blob/master/mptt/managers.py#L419 | ||
| 2011-05-05 23:55 <cedk> https://github.com/django-mptt/django-mptt/blob/master/mptt/managers.py#L679 |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!