Tips for indexing a field that keeps track of time
I have a site which has 400,000+ users and one of the fields of one of my users tables keeps track of the users last activity as a timestamp. Every time a user does something on my site, that timestamp updates to keep track of their last activity, the problem is, the query that updates the lastactivity field can take a while, up to 4 or more seconds.
Are there any good ways of going about updating a timestamp? My table is InnoDB and my database is MySQL.
Tomas Helgi Johannsson
8/22/2022 - Mon
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat