this post was submitted on 18 Oct 2024
144 points (100.0% liked)

technology

23238 readers
260 users here now

On the road to fully automated luxury gay space communism.

Spreading Linux propaganda since 2020

Rules:

founded 4 years ago
MODERATORS
 
you are viewing a single comment's thread
view the rest of the comments
[–] invalidusernamelol@hexbear.net 1 points 11 hours ago* (last edited 11 hours ago)

It's nice to be able to do something like this without having to use an ORM. Especially if you need a version of the data that's limited to a certain character size.

Like having a replica on the edge that serves the 100 character summaries then only loads the full 1000+ character record when a user interacts with it.

A summary of the review is also more useful than just the first 100 characters of a review.

If the model that's used for that is moderately light I could see it actually using less energy over time for high volume applications if it is able to lower overall bandwidth.

This is all assuming that the model is only run one time or on record update though and not every time the query is run...