Skip to content

Proxies-free.com: 100% Free Daily Proxy Lists Every Day!

Get Free Proxies Every Day

7 – Speed up Drupal login after changing user name datastore type to VARBINARY from VARCHAR

We have a project underway that requires the import of ~6 million users into Drupal (Core 7x) that have many (150K+) case-insensitive duplicate usernames. (ex: John,john,jOhn,JOHN). Importing these users with existing case and allowing them to log-in thereafter (case-sensitive) has been deemed mission-critical by stakeholders, and is a must-include feature. To facilitate this, I’ve changed the data type on the users table to VARBINARY from VARCHAR, which allows duplicate usernames with different case, and imported all users successfully.

After making this change, the problem now is that logging in takes a very long time (9-14 seconds) under no server load. I’m wondering if there are any ways to speed this up, and/or make any changes necessary that can significantly improve performance?

Index on the user table does include name. Picture attached.
db indexes

Author AdminPosted on January 5, 2021Categories ArticlesTags changing, Datastore, Drupal, login, speed, type, user, varbinary, Varchar

Post navigation

Previous Previous post: mysql – Conexion rechazada Digitalocean Cluster
Next Next post: c++ – API for value boxing and unboxing
Proxies-free.com: 100% Free Daily Proxy Lists Every Day! Proudly powered by WordPress

DreamProxies - Cheapest USA Elite Private Proxies 100 Private Proxies 200 Private Proxies 400 Private Proxies 1000 Private Proxies 2000 Private Proxies ExtraProxies.com - Buy Cheap Private Proxies Buy 50 Private Proxies Buy 100 Private Proxies Buy 200 Private Proxies Buy 500 Private Proxies Buy 1000 Private Proxies Buy 2000 Private Proxies ProxiesLive Proxies-free.com New Proxy Lists Every Day Proxies123