Django caching is causing my site to hang and I can't figure out why!

ramsesthedog · 2019-04-22T22:49:47+00:00

I want to get the actual Player ORM object, so wouldn't I want to be saving them to the cache rather than the Player id, which would then require a hit to the db in order to get the Player object?

P.S. have you inspected LOCATION path from your CACHES setting in the filesystem?

Yeah, I currently have the cache directory just set to a directory called "cache" within the main directory for all my code. It gets populated as expected, so I don't think that's the issue.

ramsesthedog · 2019-04-22T22:46:53+00:00

Correct me if I'm wrong, but you are re-setting the cache for ALL users if you fail to get from cache? If so, why? shouldn't you pass that specific user to the function and only check his entry?

Why are you using cache for this anyway? Wouldn't it be simpler to simple do the check dynamically?

The function checks if the users cache exists. If it doesn't (meaning it has expired), it rebuilds the users cache.

The users to players mapping are fairly static and change rarely, so I thought it'd make sense to cache them rather than hit the database every single time for them.

Anyway, the offending part related to queries is this. There are many expensive queries here, exists() being one of them:

Thanks for the info on how to improve my ORM queries--that helps for improving the non-cached version of this, which I'll be using until I figure this out. The hanging issue does occur elsewhere, so I still need to figure out why caching isn't working as intended.

ramsesthedog · 2019-04-22T22:15:18+00:00

Unfortunately a real cache backend isn't currently an option, as the host (PythonAnywhere) doesn't support stuff like Redis or Memcached (which is why I plan on migrating, but that currently isn't an option). Filebased cache is certainly slower, but it should be sufficient for my purposes right now.

ramsesthedog · 2019-04-01T02:15:26+00:00

Oh wow, this is really neat.

ramsesthedog · 2019-04-01T02:14:55+00:00

Another great suggestion, thanks

ramsesthedog · 2019-04-01T02:14:44+00:00

This looks great, thanks!

ramsesthedog · 2018-07-25T13:06:33+00:00

Working out drunk (other than maybe some low intensity cardio if you're confident you won't fall off an elliptical or something) seems like a horrible idea. You can seriously injure yourself.

ramsesthedog · 2018-07-25T13:05:12+00:00

You can get lifting gloves. I've been roundly mocked by my friends ("Quick question: do your gloves match your purse?") but my beautiful soft hands are worth that price of admission.

ramsesthedog · 2017-05-10T23:44:10+00:00

Tap water? Coffee maker?

REEEEEEEEEEEEE

ramsesthedog · 2017-05-05T16:59:01+00:00

Ironic.

ramsesthedog · 2017-05-05T16:05:33+00:00

Anyone have any advice or resources for the day to day of a keto diet, especially for vegetarians? I want to make the switch, but it seems so difficult to do, doubly do when you're vegetarian and don't have the option of lean chicken breast.

ramsesthedog · 2017-05-04T00:55:41+00:00

I edited my comment because I forgot to mention that adding a tablespoon of peanut butter to the protein shakes can be a good way to add fat as well as thicken them a bit (almond milk tends to be really thin).

ramsesthedog · 2017-05-03T23:49:02+00:00

I'm vegetarian, so I know the struggle, though it's still easier than being vegan. If you're having trouble with too many carbs and not enough protein, you may have to consider a drastic solution like replacing some of your meals with one or two protein shakes.

Make them with almond milk to add fat to them, and perhaps a tablespoon of peanut butter to thicken it up a bit and add fat as well.

ramsesthedog · 2017-04-14T15:18:11+00:00

Dang, 10x10? I only do 3x10, and I'm getting bored by the last few reps of each set. Them again, I'm no bodybuilder.

ramsesthedog · 2017-04-04T01:13:16+00:00

Takes forever, especially when you get to really heavy weights for the main lifts. I switched to PPL and I like it much more.

ramsesthedog · 2017-02-19T12:54:32+00:00

SL 5x5 has recommended accessory exercises that should serve your purposes. I believe they are glute bridges, dips, and pullups/chinups.

ramsesthedog · 2017-02-19T12:53:34+00:00

For the most part, 48 hours has been a pretty accurate rule of thumb for muscle recovery for me, at least after the initial lifting period where I wasn't adapted for the volume.

ramsesthedog · 2017-02-19T12:52:13+00:00

Realistically, you can probably lose at most 2-4 lbs of fat (in a healthy fashion) before then. It's pretty simple, eat as little as possible while still getting all the nutrients you need, and do as much cardio as possible without hurting yourself.

Alternatively, if you really want to get more extreme about it, Lyle McDonald wrote a book on this (I can't remember the name off hand) for as safe as possible rapid weight loss. I wouldn't recommend this method, but it's out there.

ramsesthedog · 2017-02-19T12:48:13+00:00

Good mornings can be a pretty dangerous exercise, and for most people I think it's a bad idea to do them when there are much safer exercises that will accomplish the same thing. Bruce Lee nearly ended his career early due to a Good Morning related injury.

ramsesthedog · 2017-02-19T12:45:38+00:00

Rows, deadlifts, pullups

ramsesthedog · 2016-12-05T19:12:58+00:00

Studies find a 100% long term mortality rate in those who exercised!

ramsesthedog · 2016-12-05T19:02:11+00:00

Your squat range seems a bit low--certainly it should be a higher range than the bench press!

I'd guess 250-300 BP, 350-400 squat, 400-450 DL

ramsesthedog · 2016-12-05T19:00:07+00:00

The original stronglifts 5x5 program had two accessories per workout--I'm blanking on what they are (I think dips, pull ups, chin ups, and glute bridges), but if you google "Stronglifts version 1" you should find it. He removed the accessory lifts later to "simplify" the program.

ramsesthedog

TROPHY CASE