3 ms·

I see some comments call this a "very specific user case". This is not. Pretty much every major web project is going to have tables like that. User sessions are

I see some comments call this a "very specific user case". This is not. Pretty much every major web project is going to have tables like that. User sessions are just one example. Sure, you can design around this, but it is a problem and no design is going to make it completely go away.

fleetfox 10y ago
Storing sessions in rdbms is a rather poor choice espesially at scale.
- encoderer 10y ago
  On the other hand, sessions are important and if you're only using redis/etc for caching and not as a primary data store, it may not be a very good idea to treat it as a primary store of session data. Sessions are vital for any product that works better with logged-in users.
MustardTiger 10y ago
User sessions is not an example of that, why would your user session have lots of indexes? And sessions don't belong in a database to begin with. I've never made a table like this in 15 years, and can't even think of a reason I would want to.