Dear nop commerce team,
I'm working on an online shop, where I need an extended version of nop commerce. Currently I'm working with nop 2.20.
I'm building in some new entities which I need for my purposes. This new entities have multilingual properties, i.e. a title property which should be displayed in the language of the current user.
Based on my own programming experience, I would start here the following pattern:
Entity( Id, DefaultTitle )
Entity_ML( EntityId, LanguageId, Title)
So I could load the entity and its multilingual data with one database query and so minimizing db load.
Now I see, you are using an different aproach for this. If I remember right, you load the entites and its multilingual data with separate queries. I do not want critizise anything. I'm just curious. Don't you excepct an increased db load with this approach? Or do you have any other methods for minimizing it? Maybe some sort of caching?
At the moment, am just looking for some information regarding this topic because I have to make a decission:
Keeping my pattern with Entity - Entity_ML or using your pattern. What would be your suggestion regarding this?
In the sources, I found also this classes: LocalizationExtentions, ILocalizedEntity
Could I use they for my multilingual entities?
Kind regards,
kob