I'm pretty sure there are steam API hits for every load and so the sites are tied together somehow. +1 to psyren89's comment.
Comment has been collapsed.
Things that (I guess) hit SG's DB:
Syncing account
Giveaway stuff (browsing, entering, filtering)
Separately:
Forum stuff
Commenting
Stuff that can be improved(?):
User's library list (not updated often) can be cached, should improve giveaway filtering performance
... or remove giveaway filtering altogether and point users to SGP
Lower maximum giveaway duration (less entries to track, smaller DB size?)
Cache/keep a counter of number of comments/entries on giveaways/forum threads if you don't already (so it doesn't have to be counted each time)
Enforce a minimum time between comments if you don't already
Dunno what else is possible. Bear in mind that I have very little knowledge of DBs, so someone more experienced than I could give more sound advice.
Comment has been collapsed.
2,956 Comments - Last post 10 minutes ago by Kabirbd
208 Comments - Last post 16 minutes ago by LhorXhor
17,133 Comments - Last post 23 minutes ago by Axelflox
486 Comments - Last post 35 minutes ago by Donners
15 Comments - Last post 54 minutes ago by xxxka
372 Comments - Last post 3 hours ago by UltraMaster
201 Comments - Last post 4 hours ago by paco7533
141 Comments - Last post 10 minutes ago by reigifts
100 Comments - Last post 15 minutes ago by Phantomreader42
86 Comments - Last post 19 minutes ago by pivotalHarry
107 Comments - Last post 24 minutes ago by zolof
272 Comments - Last post 28 minutes ago by Ev4Gr33n
1,766 Comments - Last post 37 minutes ago by WaxWorm
17,832 Comments - Last post 1 hour ago by Riszu
I don't know why, but SteamGifts have been loading pretty slow (to me) since last week and it's getting a little annoying since I join the page almost everyday. I've checked if it's my internet or the browser but it still loads pretty slow.
Comment has been collapsed.