News for hackers. Stuff that matters.
Re:EventReduce: An algorithm to optimize database queries th... by AmericanBlarney on Thursday April 16, 2020 @12:18PM (#22890895)
Many applications solve this by using memory caching (e.g. Redid, memcached, etc.) of performance sensitive datasets. There are a lot of drawbacks to the approach, to the point that I would avoid it altogether.
Re:EventReduce: An algorithm to optimize database queries th... by eventreduce on Thursday April 16, 2020 @05:30PM (#22893779)
The difference is that with simple caching you have to run full queries again when the cache becomes invalidated. This is often expensive especially on write intensive data usages.