[Perf] cache \Wvision\Bundle\DataDefinitionsBundle\Interpreter\AssetUrlInterpreter::deduplicateAsset
dkarlovi opened this issue · 1 comments
dkarlovi commented
Q | A |
---|---|
Bug report? | no |
Feature request? | yes |
BC Break report? | no |
RFC? | no |
Branch? | master |
With a lot of assets, doing an asset-heavy import can run this query thousands of times, and since it's using LIKE, it can be slow. We should cache the output if an asset is found so we can speed up the process.
dkarlovi commented
This doesn't work well enough, we should actually change how we store the URL instead and remove LIKE %URL%
.