Hynek, You're right. I appreciate the in-depth analysis you've been doing on optimizing Satchmo's queries. You are probably right that we should optimize the configuration so that we don't try to query translations. I'm open to ideas/patches.
-Chris On Sat, Jul 17, 2010 at 6:59 AM, hynekcer <[email protected]> wrote: > Satchmo is now optimized for eshops with many translations which have > on the average translated more than three variants of the same > language, for example en_us, en_gb, en_au, en_ca, fr_be, fr_ca, fr_ch, > fr_fr :-)) > > Satchmo searches for every name first for count of translations to > language exactly "xy" than for count of translations to languages > starting with letters "xy" and than probably for the translated texts > if the count is not zero. > > On the Search results page it does the same individual query for every > found category and all its parents, even repeatedly for the same > parent, even if the name of parent is never printed on that page. It > tries to translate even to the default language of eshop, the only > installed language. ?? > > More efectively would be to test on startup if there is any translated > item in any of tables producttranslation, categorytranslation, product > image, category image, option, option group. If not, it can give up > hundreds of necessary queries. > Seriously: Translations can make considerable load in runtime. I do > not understand it. > > Hynek > -- > Brian O'Connor wrote: > > Out of curiosity, is there any approximate estimate on how much the > > translations are used? I've never used it, so I can't say myself. > > -- > You received this message because you are subscribed to the Google Groups > "Satchmo users" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<satchmo-users%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/satchmo-users?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Satchmo users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/satchmo-users?hl=en.
