valdisiljuconoks / localization-provider-opti

Database driven localization provider for Optimizely (ex. Episerver) websites
Apache License 2.0
11 stars 17 forks source link

LocalizationResources table allows duplicated rows #234

Open quanmaiepi opened 2 weeks ago

quanmaiepi commented 2 weeks ago

It should be unique for each ResouceKey, or combination of ResourceKey, language. In one example we noticed extreme duplications with the most duplicated rows repeated 358209 times, and 17 keys with > 10k duplications. That of course brings the database to the knee every time it was queried.

quanmaiepi commented 2 weeks ago

@valdisiljuconoks I think you are already aware of this issue, but maybe good to bring this up so other users know about it

valdisiljuconoks commented 2 weeks ago

it's already enforced in the latest version