Open garryn opened 5 years ago
Please add indexes to the seoURL table for url and context_key as a minimum.
seoURL
url
context_key
The lookup becomes very inefficient when the table contains a large number of rows (e.g. 200k) without properly defined indexes.
@garryn That would be a great improvement. Thank you for opening this issue. I've added it on our roadmap.
Please add indexes to the
seoURL
table forurl
andcontext_key
as a minimum.The lookup becomes very inefficient when the table contains a large number of rows (e.g. 200k) without properly defined indexes.