CODEWITHSUNDEEP
phpmysqldatabasememcachedmembase
user1104791
user1104791

Reputation:

Memcached Storing user accounts

I'm curious about speeding up my site using memcache. Now currently I have a mysql table with columns for a key and email address, users log in using their key and I query the database to check if it's correct. The email is used incase they forget their key and want it resending.

Now, obviously each record is very small (about 19B I think). Do you think it would be a good idea to preload all (Say, 1 million records) the records into Memcached and only use Mysql for keeping a permanent record?

Upvotes: 3

Views: 533

Answers (2)

Nitesh morajkar
Nitesh morajkar

Reputation: 431

If you are using just 1 server, then Memcached won't prove useful. Also, when alloted memory for memcached is used completely, then memcached would overwrite the the last key. (LIFO). Storing user information in Memcache won't be ideal

Upvotes: 0

Drahkar
Drahkar

Reputation: 1671

Memcached is intended to be a short term caching solution handle key=value pairs. While you could, in theory, use it for something like this, it isn't the intended use for it and honestly I don't think you really gain anything for it.

Generally the best thing to use Memcached for is activities like dynamically generated content that you want to keep consistent along a session and accessible from multiple servers (Like an load balanced environment.

Upvotes: 1

Related Questions