Re: Redis 16 times faster than Postgres?

from the original article:
> For example, the PostgreSQL speeds depend on the Django ORM code
> that makes the SQL and sends the query and then turns it into the model
instance.
> I don't know what the proportions are between that and
> the actual bytes-from-PG's-disk times. But I'm not sure I care either.

imho: the "Django ORM" is not so fast.
according to "TechEmpower Web Framework Benchmarks" ...
it has only ~3% performance - compare to the best rust+pg (100%) results.

example:
"Data updates"
https://www.techempower.com/benchmarks/#section=data-r18&hw=ph&test=update
the "django-postgresql" performance = 766 - only 3.0% of the best pg +
rust results
checking the other test types ( "Single query" ;" Multiple queries" ) has
a similar results.

the Django implementation of the test:
https://github.com/TechEmpower/FrameworkBenchmarks/tree/master/frameworks/Python/django

Imre

Colin 't Hart <colinthart(at)gmail(dot)com> ezt írta (időpont: 2019. szept. 29.,
V, 23:42):

> Hi,
>
> Can someone take a look at this blog post?
> https://www.peterbe.com/plog/redis-vs-postgres-blob-of-json
>
> Can Redis really be 16 times faster than Postgres? Surely Postgres can get
> closer to the raw speed of the hardware than 1 order of magnitude?
>
> Thanks,
>
> Colin
>