Problem/Motivation

Only the prime key has an index. The module will perform better if it has more indexes.

Proposed resolution

Add indexes to visitors_uid, visitors_date_time, visitors_ip.

Issue fork visitors-3250285

Command icon Show commands

Start within a Git clone of the project using the version control instructions.

Or, if you do not have SSH keys set up on git.drupalcode.org:

About issue forks

Comments

j.b created an issue. See original summary.

j.b’s picture

j.b commented
Issue summary: View changes
bluegeek9’s picture

bluegeek9 commented
Status: Active » Postponed (maintainer needs more info)

@jb How did this work out? Did you have performance issues? Which CRM system are you using?

bluegeek9’s picture

bluegeek9 commented
Title: Performance of this module » Performance: Add db indexes
Version: 8.x-2.7 » 7.x-1.x-dev
Component: Miscellaneous » Code
Priority: Critical » Normal
Issue summary: View changes
Status: Postponed (maintainer needs more info) » Active
bluegeek9’s picture

bluegeek9 commented
Version: 7.x-1.x-dev » 8.x-2.x-dev
Category: Support request » Feature request
bluegeek9’s picture

bluegeek9 commented
Issue summary: View changes
Status: Active » Needs review

This is intended as part of the 8.x-2.17 release.

bluegeek9 opened merge request !82

  • bluegeek9 committed d4e4d62f on 8.x-2.x 
    Issue #3250285: Performance: Add db indexes
bluegeek9’s picture

bluegeek9 commented
Status: Needs review » Fixed
bluegeek9’s picture

bluegeek9 commented
Status: Fixed » Active

The columns should not be renamed. Renaming columns should not happen in minor releases, only a new 3.x branch

bluegeek9 opened merge request !84

  • bluegeek9 committed 89aaadd9 on 8.x-2.x 
    Issue #3250285 by bluegeek9: Performance: Add db indexes
bluegeek9’s picture

bluegeek9 commented
Issue summary: View changes
Status: Active » Fixed

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.

bluegeek9’s picture

bluegeek9 commented

This issue was resolved. A new release, 8.x-2.17, will be made soon, May 31st.

This is an excellent opportunity to beta test the dev branch, and report any issues.

Contributors (5)

bluegeek9, roshni27, abhishek_gupta1, sarwan_verma, SandeepSingh199

Changelog

Issues: 32 issues resolved.

Changes since 8.x-2.16:

Bug

Feature

Task