IRC logs of #tryton for Thursday, 2010-01-07

chat.freenode.net #tryton log beginning Thu Jan 7 00:00:02 CET 2010
-!- vengfulsquirrel(n=ian@c-69-181-194-95.hsd1.ca.comcast.net) has left #tryton00:51
-!- ikks(n=ikks@190.158.102.38) has joined #tryton01:56
-!- yangoon(n=mathiasb@p549F6D19.dip.t-dialin.net) has joined #tryton05:20
-!- udono(n=udono@dynamic-unidsl-85-197-24-177.westend.de) has joined #tryton06:28
-!- udono(n=udono@dynamic-unidsl-85-197-24-177.westend.de) has joined #tryton06:30
-!- bechamel(n=user@host-85-201-159-186.brutele.be) has joined #tryton08:25
-!- Timitos(n=timitos@88.217.184.172) has joined #tryton08:31
-!- FWiesing(n=FWiesing@194-208-185-012.tele.net) has joined #tryton09:05
-!- FWiesing(n=FWiesing@194-208-185-012.tele.net) has left #tryton09:11
-!- sharoon(n=sharoont@117.197.58.161) has joined #tryton10:48
-!- paepke(n=paepke@79.235.39.152) has joined #tryton10:59
-!- paepke(n=paepke@p4FEB2798.dip0.t-ipconnect.de) has joined #tryton11:55
-!- sharoon(n=sharoont@117.197.57.172) has joined #tryton12:12
-!- yangoon(n=mathiasb@p549F6D19.dip.t-dialin.net) has joined #tryton14:53
-!- essich(n=essich@p4FCF9611.dip0.t-ipconnect.de) has joined #tryton15:33
-!- johbo(n=joh@statdsl-085-016-072-173.ewe-ip-backbone.de) has joined #tryton16:05
-!- cedk(n=ced@gentoo/developer/cedk) has joined #tryton16:48
-!- woakas(n=woakas@190.144.69.234) has joined #tryton17:28
-!- essich(n=essich@p4FCF9611.dip0.t-ipconnect.de) has joined #tryton17:36
-!- sharoon(n=sharoont@117.197.57.172) has left #tryton18:47
-!- LucaSub1(n=LucaSub@host158-190-dynamic.9-87-r.retail.telecomitalia.it) has joined #tryton20:06
-!- vengfulsquirrel(n=ian@c-69-181-194-95.hsd1.ca.comcast.net) has joined #tryton20:13
vengfulsquirrelHi what does select=1 do on a model property?20:33
cedkvengfulsquirrel: it adds index on column of table20:39
vengfulsquirrelSo for each model property it adds a single index of just that column ?  Or does it add composite indices as well somehow?20:39
vengfulsquirrelI was looking at this patch: '''Add select=1 on res and field of ir.property20:40
vengfulsquirrelIt is the two fields on which get/set functions make search '''  and was curious if it would help my slowness situation.20:40
cedkyes, search must be faster20:43
vengfulsquirrelYeah, well there are 23,000 rows in ir_property.  I don't really understand how that comes into play.20:49
cedkvengfulsquirrel: I don't understand what you don't understand20:50
cedkvengfulsquirrel: any way, tell us if it improves the situation21:02
vengfulsquirrelcedk: Hmm yeah doesn't seem to have any effect at least in the specific case I use to recreate my problem.21:19
vengfulsquirrelIr is responsible for just tracking models and their properties right?  Those probably are not accessed repeatedly in one client request besides a few times per model right?21:20
udonovengfulsquirrel: hi, maybe you need to reindex the ir_sequence table? There is a function in pgadmin. But I don't know if it is related21:23
udonosorry, ir_property...21:24
vengfulsquirrelWell I guess my question is do you think indexing ir_property or not will really have tremendous impact on performance?21:24
vengfulsquirrelI mean it will be "faster" but would it be noticeable ?21:25
udonovengfulsquirrel: good question...21:26
cedkir_property is used for each Property field21:56
cedklike cost_price on product etc.21:56
vengfulsquirrelcedk,udono: Sorry, okay I have another question, the times returned when I do this(in trytond/backend/postgresql/database.py : execute) don't seem correct, does self.cursor.execute not happen immediately ? http://paste.pocoo.org/show/163070/22:01
cedkvengfulsquirrel: it is22:03
vengfulsquirrelIt does you mean?22:04
cedkvengfulsquirrel: yes, it does22:04
cedkvengfulsquirrel: why do you say it doesn't seem correct?22:05
vengfulsquirrelWell my crude time printing method prints this : 0:00:00.00371622:05
vengfulsquirrelbut EXPLAIN ANALYZE says it takes 7 seconds22:05
vengfulsquirrelOh I'm an idiot22:07
cedkvengfulsquirrel: I think the time is the time of your query "explain"22:07
vengfulsquirrelOkay well there were a lot of things wrong with what I was doing but the conclusion is those queries most likely aren't causing the 5 - 10 minute lag.22:15
vengfulsquirrelI misread the analyzer and its 7 milliseconds and I had the datetime.now() BEFORE the execute instead of after.22:16
-!- FWiesing(n=FWiesing@194-208-185-012.tele.net) has joined #tryton22:31
vengfulsquirrelMaybe its possible that the large amount of data is difficult to load in python even though the database can pull it in a fair amount of time?22:31
vengfulsquirrelI asked this the other day too, why are all the fields on my model pulled(lines) when I return from viewing a single model using switch, here is the output of the client using -v, 1. I get the list of inventories(no lines field is requested), 2. I view the inventory (the lines are requested for that single inventory) 3. I click switch to go back to the list of inventories(all the inventories AND their lines are requested--why?) ht22:32
vengfulsquirrelThat's about 80,000 records.22:42
vengfulsquirrelI think it might be a bug because sales also exhibit the same behaviour.23:07
-!- juanfer(n=juanfer@190.27.146.29) has joined #tryton23:13
-!- cedk(n=ced@gentoo/developer/cedk) has joined #tryton23:25
cedkvengfulsquirrel: I tried on sale with 160 orders and when I switch back to list view it prefetch only the 80 first sales23:27
vengfulsquirrelYeah you are right, its not getting all the sales.23:28
vengfulsquirrelIs there a way I can make the switch behave the same as the initial view>23:29
vengfulsquirrel*?23:29
cedkvengfulsquirrel: it should do by default23:29
vengfulsquirrelYeah but do you see how it fetches different columns/fields.23:29
vengfulsquirrel*?23:29
cedkvengfulsquirrel: yes because now the client knows more fields of the model23:30
CIA-5C?dric Krier <ced@b2ck.com> default * 1479:10a10dc4e869 tryton/tryton/gui/window/view_form/view/form_gtk/one2many.py: Use the same behavior for F3 on one2many even if add_remove is set.23:32
CIA-5http://hg.tryton.org/tryton/rev/10a10dc4e86923:32
cedkvengfulsquirrel: but it must not affect the speed23:35
cedkvengfulsquirrel: except if you have function fields that doesn't scale23:36
vengfulsquirrelHow will I know if they don't scale?23:42
cedkvengfulsquirrel: by algorithm analysis23:43
-!- paepke(n=paepke@p54A2A4F3.dip0.t-ipconnect.de) has joined #tryton23:44
cedkvengfulsquirrel: it can be of the orders: O(1), O(log(n)), O(n), O(n²) etc23:45
CIA-5C?dric Krier <ced@b2ck.com> default * 2127:b3a76ce4635f trytond/bin/trytond: Fix profile mode and use --profile argv23:46
CIA-5http://hg.tryton.org/trytond/rev/b3a76ce4635f23:46
CIA-5C?dric Krier <ced@b2ck.com> default * 1480:32b0c400fb98 tryton/ (bin/tryton tryton/client.py tryton/config.py): Add profile mode and use --profile argv23:46
CIA-5http://hg.tryton.org/tryton/rev/32b0c400fb9823:46
vengfulsquirrelYeah I had a check_ method in _constraints, but that only applies when saving the record right ?23:47
vengfulsquirrelI have get_uom and get_digits and those are the only two Function fields in the Inventory or InventoryLine models in my code.23:47
CIA-5C?dric Krier <ced@b2ck.com> default * 1481:33f3b34f0ae0 tryton/tryton/gui/main.py:23:49
CIA-5Don't call sys.exit as it breaks profile23:49
CIA-5See http://bugs.python.org/issue597823:49
CIA-5http://hg.tryton.org/tryton/rev/33f3b34f0ae023:49
cedkvengfulsquirrel: yes for check_ and _constraints23:49
cedkvengfulsquirrel: you should find where the server spends time23:50
vengfulsquirrelYeah I have tried the profiler, its really hard to sift through all the stuff that's going on.23:50
cedkvengfulsquirrel: first what the call from the client?23:51
-!- vengfulsquirrel(n=ian@c-69-181-194-95.hsd1.ca.comcast.net) has left #tryton23:51
-!- vengfulsquirrel(n=ian@c-69-181-194-95.hsd1.ca.comcast.net) has joined #tryton23:51
vengfulsquirrelSorry pressed emacs key23:51
vengfulsquirrelWhat do you mean what is the call ?23:52
cedkvengfulsquirrel: the call that the client does that take long time23:53
vengfulsquirrelI only ran the profiler on the server23:56
vengfulsquirrelside23:56
vengfulsquirrelShould I run it on the client side?23:56
cedkvengfulsquirrel: no23:56

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