Performance optimization: Add an Index to the userlink SQL table:

CREATE INDEX idx_vid
on userlink (vid)

userlink_load queries are executed within less than 2 ms where it took between 25 and 30 ms before we added the index to the table.

Comments

pomliane’s picture

pomliane commented
Status: Active » Closed (won't fix)

This version of userlink is not supported anymore. The issue is closed for this reason.
Please upgrade to a supported version and feel free to reopen the issue on the new version if applicable.

This issue has been automagically closed by a script.