| chat.freenode.net #tryton log beginning Thu 20 Feb 2020 12:00:01 AM CET | ||
| -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | 23:18 | |
| -!- Timitos(~kpreisler@2001:a61:426:7801:762b:62ff:fe84:ed7e) has joined #tryton | 07:03 | |
| -!- mrichez(~Maxime@mail.saluc.com) has joined #tryton | 07:23 | |
| -!- rpit(~rpit@p5B22B909.dip0.t-ipconnect.de) has joined #tryton | 07:28 | |
| -!- josesalvador(~josesalva@84.124.29.26.static.user.ono.com) has joined #tryton | 07:50 | |
| -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | 07:52 | |
| semarie | cedk: about issue9064 ("Duplicate payment in workflow transition"), in rietveld comment, you said "Once we use set, the cache of the instances are no more aligned, so it is better to recreate a a list with ModelStorage.browse". I think that "no more aligned" mean that the order of argument is important for caching. Where the cache occurs ? on Payment.fail() call ? with some mixing to do the caching | 07:59 |
|---|---|---|
| semarie | ? | 07:59 |
| semarie | I am trying to understand to avoid to repeat the same error every time :) | 08:00 |
| cedk | semarie: the ORM knows for each record the list it comes from | 08:12 |
| cedk | semarie: so when it fetch data for a record indeed it optimize and prefetch data for x more record after in the list at once | 08:13 |
| cedk | this is because make a query to the database is more expensive than retrieve more data in a single query | 08:13 |
| cedk | so the loop order of set is undefined in Python, this means that the next record may not be prefetched and so we loose this optimization | 08:14 |
| -!- nicoe(~nicoe@2a02:578:852a:c00:7e2a:31ff:fe5e:b25d) has joined #tryton | 08:20 | |
| -!- nicoe(~nicoe@2a02:578:852a:c00:7e2a:31ff:fe5e:b25d) has joined #tryton | 08:42 | |
| -!- nicoe(~nicoe@host-85-201-184-151.dynamic.voo.be) has joined #tryton | 09:16 | |
| -!- mrichez(~Maxime@mail.saluc.com) has joined #tryton | 10:55 | |
| -!- mariomop(~quassel@190.247.127.226) has joined #tryton | 12:32 | |
| -!- josesalvador(~josesalva@170.253.41.74) has joined #tryton | 14:53 | |
| -!- josesalvador1(~josesalva@170.253.35.165) has joined #tryton | 15:50 | |
| cedk | any one know a pastebin for SQL query? | 19:20 |
| cedk | I found https://explain.depesz.com/ | 19:25 |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!