You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Instead we could perform one query first to check if there is a idvisitor = ? and if not execute a second query with config_id = ? AND user_id IS NULL
We noticed on a DB with many log entries that this visitor recognition query is rather slow and this should improve it as in most cases a visitor based on idvisitor should be found. Even if not, it should not be slower that way.
The text was updated successfully, but these errors were encountered:
As discussed with @quba I think the union here is not needed: https://github.com/piwik/piwik/blob/2.13.0-rc2/core/Tracker/Model.php#L382-L386
Instead we could perform one query first to check if there is a
idvisitor = ?
and if not execute a second query withconfig_id = ? AND user_id IS NULL
We noticed on a DB with many log entries that this visitor recognition query is rather slow and this should improve it as in most cases a visitor based on
idvisitor
should be found. Even if not, it should not be slower that way.The text was updated successfully, but these errors were encountered: