IRC logs of #tryton for Wednesday, 2014-01-29

chat.freenode.net #tryton log beginning Wed Jan 29 00:00:01 CET 2014
2014-01-29 10:05 <grasbauer> Hello
2014-01-29 10:09 <grasbauer> I just installed production module to see the new calendar view but nothing shows up - whats to do?
2014-01-29 10:15 <cedk> grasbauer: did you installed GooCalendar ?
2014-01-29 10:15 <grasbauer> cedk: OMG
2014-01-29 10:15 <grasbauer> cedk: thanks
2014-01-29 13:56 <grasbauer> anybody has more than 200.000 products in the database? My local box goes crazy if I do a sale and type the name of the product in the form of the sales line. Seems like search_rec_name is to heavy ...
2014-01-29 13:57 <yangoon> grasbauer: yes, it is a known issue also for us, when doing rather undetailed searches
2014-01-29 13:58 <grasbauer> yangoon: mhhhh
2014-01-29 14:00 <grasbauer> yangoon: any solution?
2014-01-29 14:05 <yangoon> grasbauer: not so far apart from telling our customers to use detailed search clauses. I didn't have the time so far to dig in.
2014-01-29 14:06 <grasbauer> yangoon: ok
2014-01-29 14:23 <nicoe> grasbauer: does it happen with the autocompletion box in the sale line?
2014-01-29 14:23 <grasbauer> nicoe: yes
2014-01-29 14:25 <cedk> grasbauer: probably because of the translation and search_rec_name could be improved to use 'OR'
2014-01-29 14:27 <grasbauer> nicoe: ok - but I don't know where to place 'OR' :)7
2014-01-29 14:45 <grasbauer> cedk , nicoe: dont kow why - but now it works much faster - probably the index was not up to date
2014-01-29 14:48 <cedk> grasbauer: http://hg.tryton.org/modules/product/file/f5f3bdceddd0/product.py#l182
2014-01-29 14:48 <cedk> grasbauer: this should have poor performence if ids is large
2014-01-29 14:51 <grasbauer> cedk: ok
2014-01-29 15:25 <rmu> grasbauer: product.search_rec_name should probably be replaced with something like return ['OR', [('code',) + tuple(clause[1:])], [('template.name',) + tuple(clause[1:])]]
2014-01-29 15:26 <grasbauer> rmu: will give it a try
2014-01-29 17:25 <pokoli> grasbauer: have the proposed code solved your problem?
2014-01-29 18:52 <rmu> pokoli: this pattern probably occurs in many places, perhaps it should all be fixed/improved in one codereview
2014-01-29 18:56 <pokoli> rmu: yes, so we may add an issue to improve this :)
2014-01-29 20:17 -!- vcardon(~vcardon@LNeuilly-152-23-15-185.w193-252.abo.wanadoo.fr) has left #tryton

Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!