Hot answers tagged

4 votes

Best way to store quite large JSON objects?

You have an interesting scenario with lots of solution that might be appropriate. You raise a good point that the amount of data might be an issue. As a worst case estimate, you might have 0.5MB per ...
amon's user avatar
  • 133k
3 votes

Handling simultaneous duplicate expensive read-only HTTP requests

You can move the caching/polling logic into the server, for example by writing some middleware for this. A key insight is that a cache entry cannot just be present or absent, but also pending. An ...
amon's user avatar
  • 133k
3 votes

Optimizing writes over the same entity in relational DB

Although the frequency of updates per minute may not seem excessive, and your database should have no difficulty handling it, it may be worth considering implementing an in-memory buffer to keep track ...
George's user avatar
  • 168
2 votes

Optimizing writes over the same entity in relational DB

Roll a new GUID for each voting event, and append a one-line entry to a text file of votes, perhaps in CSV format. Either fsync() the write immediately, or have a background thread issue fsync's every ...
J_H's user avatar
  • 2,912
1 vote

How can I implement a lazy-loading cache for REST objects with custom role-based access?

TL;DR Add a seperate cache for the role(s) a user has. The core premise of a "normal" cache is that it is quicker to fetch the previously returned value (typically from memory) than it is ...
DavidT's user avatar
  • 1,214
1 vote

Optimizing writes over the same entity in relational DB

About performance Your concern is legit, but I think you should start addressing the issue from a different angle first. Focus first on the connection pool size. Regarding Java's connection pool, it ...
Laiv's user avatar
  • 14.3k

Only top scored, non community-wiki answers of a minimum length are eligible