IRC logs of #tryton for Thursday, 2011-05-05 #tryton log beginning Thu May 5 00:00:03 CEST 2011
-!- GasbaKid(~GasbaKid@ has joined #tryton00:02
-!- vladimirek( has joined #tryton00:16
-!- ikks(~ikks@ has joined #tryton00:53
-!- zodman( has joined #tryton00:53
-!- zodman(~andres-va@foresight/developer/zodman) has joined #tryton00:53
-!- GasbaKid(~GasbaKid@ has joined #tryton01:23
-!- curlynostrilll(~curlynost@ has joined #tryton02:21
-!- effenber1( has joined #tryton04:15
-!- alimon(~alimon@ has joined #tryton04:36
-!- yangoon( has joined #tryton05:19
-!- alimon(~alimon@ has joined #tryton06:07
-!- elbenfreund( has joined #tryton06:21
-!- nicoe( has joined #tryton07:05
-!- nicoe_( has joined #tryton07:25
-!- nicoe( has joined #tryton07:29
-!- nicoe( has joined #tryton07:32
-!- nicoe( has joined #tryton07:52
-!- nicoe( has joined #tryton08:04
-!- okko( has joined #tryton08:23
-!- sharkcz(~sharkcz@2001:15c0:6747:160:250:43ff:fe3c:3b5d) has joined #tryton08:46
-!- okko( has joined #tryton08:50
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton09:08
-!- pjstevns( has joined #tryton09:21
-!- blast_hardcheese( has joined #tryton09:23
-!- okko( has joined #tryton09:58
-!- okko( has joined #tryton10:00
-!- bechamel( has joined #tryton10:04
-!- okko( has joined #tryton10:06
-!- nicoe( has joined #tryton10:17
-!- okko( has joined #tryton10:39
-!- gavinf( has joined #tryton10:46
-!- gavinf( has left #tryton10:48
-!- heffer(~felix@fedora/heffer) has joined #tryton12:05
-!- many( has joined #tryton12:06
-!- elbenfreund1( has joined #tryton12:52
-!- rhubner(~rhubner@ has joined #tryton14:05
rhubner\j #gsoc-br14:06
-!- rhubner(~rhubner@ has left #tryton14:06
-!- rhubner(~rhubner@ has joined #tryton14:07
-!- alimon(~alimon@ has joined #tryton15:11
-!- rhubner(~rhubner@ has left #tryton15:43
-!- gavinf( 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
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( has joined #tryton16:35
-!- gremly(~gremly@ has joined #tryton17:34
-!- elbenfreund2( has joined #tryton17:37
-!- sharoon( has joined #tryton17:51
-!- elbenfreund( has joined #tryton17:55
-!- FWiesing( has joined #tryton18:36
-!- alimon(~alimon@ has joined #tryton18:55
-!- gremly(~gremly@ has joined #tryton18:59
-!- vladimirek( has joined #tryton19:48
-!- nicoe( has joined #tryton20:04
-!- FWiesing( has left #tryton20:06
-!- nicoe( has joined #tryton20:18
-!- nicoe( 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
cedksharoon: don'T understand20:31
cedksharoon: that is not possible20:32
sharooncedk: i got the idea from here:
sharooncedk: let me paste what i did onto a pastie20:33
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
cedksharoon: could you try:
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, 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
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( has joined #tryton21:06
cedksharoon: something like
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
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
sharooncedk: reading21:19
cedkACTION bbl21:20
-!- gremly(~gremly@ has joined #tryton21:25
yangooncedk: I get the 500, when 'Send mail' is activated on Publish + Mail Draft Comments21:38
-!- elbenfreund1( has joined #tryton21:56
-!- bechamel( has joined #tryton22:09
-!- curlynostrill(~curlynost@ has joined #tryton22:11
-!- okko( has joined #tryton22:19
-!- plantian( has left #tryton22:42
-!- enlightx(~enlightx@ has joined #tryton23:09
sharooncedk: we already have this feature right ?
cedksharoon: yes23:52
cedksharoon: you should have a look at23:54

Generated by 2.11.0 by Marius Gedminas - find it at!